rishabhgupta
New Member
- Joined
- Jan 21, 2014
- Messages
- 2
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
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