Previous Topic Next Topic

Select listbox item w/option of 2 macros

Closed
LOSTandCONFUSED - Jun 18, 2010 at 02:13 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 18, 2010 at 06:33 PM
Hello,
I am new to VBA, I have created a listbox of names. What I want to do is when the user selects a name they will select 1 of 2 buttons.

Button 1 will open the workbook associated with that name, it should call one of three macros to run

Button 2 opens up the workbook associated with that name as read only

then I have a close button to unload the userform

Am I off base doing it this way?

Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 18, 2010 at 06:33 PM
You lost me from this sentence onward "What I want to do is when the user selects a name they will select 1 of 2 buttons. '


Do you have some file or template or some thing that shows what you want to do,. If yes, Could you please upload a sample file on some shared site like https://authentification.site , http://wikisend.com/ ,https://accounts.google.com/ServiceLogin?passive=1209600&continue=https://docs.google.com/&followup=https://docs.google.com/&emr=1 http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
0