Need to code for VBA Excel

Use variable declaration.

Ask for name( use input box) spell the name by letters and change to opposite size (small to large, large to small) and write result to file.