Userform called in macro

[rishabhgupta]

Hi,

i have created some textboxes and assigned different macro to them.
i have created these text boxes to call different sheets.
same userform has been called to different macros, userform contains two button 'ok' and 'cancel'.
i need to activate sheet by clicking 'ok' in userform and the name of the sheet that got activated should be same as text in the box.
how to write code in 'ok' button so that it recognize which text box has called this userform..

Thanks

 

[patel45]

can you provide a link to a sample file ?

 

[royUK]

Depending on what the code does that is attached it is unnecessary to actually activate worksheets for the code to work.

 

[rishabhgupta]

Depending on what the code does that is attached it is unnecessary to actually activate worksheets for the code to work.

But i want to open that sheet by clicking Ok button on userform.
can i declare a global variable in module and assign a value to this variable inside macro, this macro is called when i click on button.
then using this variable can i activate sheet??

I am totaly new to VBA. please help..

 

[royUK]

You've already been asked to provide a link to your workbook.

However, the best way is to forget about TextBoxes and use a Listbox to list all the sheets in the workbook.

Example WorkBook