I am trying to print word documents from an excel userform which lists documents as radio buttons captions. When radio button selected I can see the document name as "SelectedOption" in a message box. When I then start a module code "automateword" the value of "SelectedOption" is dropped. How can I pass it on??
Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by nigelog; 06-22-2018 at 05:04 AM.
Where have you declared SelectedOption?
By the way, have you considered reading the value(s) directly from the userform in the automateword sub?
Please Login or Register to view this content.
If posting code please use code tags, see here.
Or set a Global variable.
Please Login or Register to view this content.Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Hi Norie
thanks, I forgot to Dim as String...works now but I'll have a look at your option
@Bakerman
I might take this opportunity to learn about global variables...Ta
You should simply pass the variable as an argument, rather than using a public variable or back referencing the userform
Please Login or Register to view this content.
@Andy
A lot of options - I often wondered what the bracketed expressions were on a sub title.
I'll have a look through all suggestions to familiarise myself
all I need to find now is to add "If word document already open option"
Thanks all for the help
Nigelog, thanks for rep+.
Something like this.
GetObject checks wether Word is open, if not CreateObject takes over.Please Login or Register to view this content.
But I'd suggest you start a new thread if you want to continue on this subject.
No problem
thanks Bakerman
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks