Category Archives: Excel

No Thumbnail

Excel Custom Formatting, @ Character

If you’ve been reading about custom formatting in Excel you’ve probably stepped on the @ character. So what is it? For input values of the text type the @ character specifies where to put the the text. I will explain this using examples – Example

No Thumbnail

File and Folder Dialoges VBA

You have probably worked with file and folder dialogues before. Selecting a file to open choosing a path to save the current file choosing a directory path Although it would seem that the dialog itself does the saving and opening, but most dialogues actually don’t do any of that.