Retain the state of an inputbox's default input for successive runs

**MCCCLXXXV** · 05-05-2011, 08:28 AM

Is there a way to do the following:

1. run the macro below through to the end
2. run it a second time, but this time the default of the inputbox is set to whatever the user had typed in the first time.

Thanks!

Please Login or Register  to view this content.

**mohd9876** · 05-05-2011, 08:44 AM

Dear MCCCLXXXV,

yes you can do that if you declare the variable sDef as static like this:

Please Login or Register  to view this content.

hope it helps

**MCCCLXXXV** · 05-05-2011, 10:02 AM

Perfect - that's exactly what I needed! Thanks so much!

-JR

Retain the state of an inputbox's default input for successive runs

LinkBack

Thread Tools

Rate This Thread

Display

Retain the state of an inputbox's default input for successive runs

Re: Retain the state of an inputbox's default input for successive runs

Re: Retain the state of an inputbox's default input for successive runs

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions