Prompt to modify code

[randell.graybill]

Hi all I was wondering if anyone knew how to add in a text box prompt that will modify code?

Please Login or Register  to view this content.

[JBeaucaire]

Modify how? Putting in a msgbox and based on the answer using different portions of code is doable...

Please Login or Register  to view this content.

Or, you can use an INPUTBOX to change the way macros are applied altogether. An input box value can be fed into macros as sheetname changes, date range adjustments, name filters, range filters... pretty much anything you can imagine.

What do you have in mind?

[randell.graybill]

you see in the code where it says "Picking Diffences 04-01-2009 Daily.xls" I want the prompt to ask the user to input the date they are checking and the code should use the date they inputed into the box for each time "Picking Diffences 04-01-2009 Daily.xls" appears. so for example if I put in "Picking
Diffences 04-21-2009 Daily.xls" in the text box the code should read "Picking Diffences 04-21-2009 Daily.xls" each time "Picking Differences is referenced.

[JBeaucaire]

This code results in a string called "TheString" which you can insert throughout the rest of your code instead of the file name. It asks for a date, evaluates it and inserts it into your filename. I left a message box popup so you would see the name of the result:

Please Login or Register  to view this content.

For example:

Please Login or Register  to view this content.

[randell.graybill]

Thanks a bunch works like a charm.