Adding a user-entered "Title" to Save file name

[youngtusk87]

Hey folks, hope everyone is having a great day.

Need some help with saving file names. When a user executes the macro I have, after doing all sorts of crude programming, it ends the macro with automatically saving multiple conversions of the Worksheet each with a unique file name and identical date & time stamps. However, after using the macro for a while I have realized the value of having a customized title depending on what items were compiled(such as manufactures, types of figures, etc).

I set up a Text Box that says "Enter Title Here" and I was wondering if there is an easy way to:
1) Check if the Text Box has been modified from the default "Enter Title Here"
2a) If it has, assign the value of the Text Box to a string
2b) If it has not, assign an empty value to the string

From then on I can just insert the string into the file names to be saved; I know that much

Thanks in advance.

Love,
Tusk

[TMS]

Why don't you just use an Input Box with a default of "Enter Title Here".

Regards, TMS

[youngtusk87]

Thanks for the reply TMS!

I did some research and it seems like a practical solution. But I don't want a window popping up asking for the information, I'd rather the input be passive instead of reactive. In terms of functionality a Input Box seems better but I am foremost a designer(hence why I'm asking for help on here so often! =P) and if there is a way of doing it without a window prompt popping up that would be ideal for my purposes.

Alternatively, if there is a way to format the InputBox such that it is seamlessly integrated into the Worksheet that would be great too. However, based on my research it doesn't have that sort of capability.

Edit: This was easier than I thought it would be. I figured I would be too busy at work to figure it out myself but I got some down time and here is the code I got in case anyone needs it or Googles it to the forums.

Please Login or Register  to view this content.

[TMS]

Well done for solving your own problem ... and thanks for sharing.

Thanks for the rep.