![]() |
Text Box Macro
Is it possible to create a macro that when it is run a big text box opens
that is about the size of the screen and the text box can hold approx 151 controls including 1 control that closes the text box and 150 other controls that macros can easily be assigned to each one just like a macro can be assigned to a check box or button? |
Text Box Macro
You should place your controls in the user form; and not within the text
box..You can call the assigned macro using Call <ProcedureName If this post helps click Yes --------------- Jacob Skaria "TGalin" wrote: Is it possible to create a macro that when it is run a big text box opens that is about the size of the screen and the text box can hold approx 151 controls including 1 control that closes the text box and 150 other controls that macros can easily be assigned to each one just like a macro can be assigned to a check box or button? |
Text Box Macro
Thank you sir
"Jacob Skaria" wrote: You should place your controls in the user form; and not within the text box..You can call the assigned macro using Call <ProcedureName If this post helps click Yes --------------- Jacob Skaria "TGalin" wrote: Is it possible to create a macro that when it is run a big text box opens that is about the size of the screen and the text box can hold approx 151 controls including 1 control that closes the text box and 150 other controls that macros can easily be assigned to each one just like a macro can be assigned to a check box or button? |
All times are GMT +1. The time now is 07:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com