ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Text Box Macro (https://www.excelbanter.com/excel-programming/427492-text-box-macro.html)

TGalin

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?

Jacob Skaria

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?


TGalin

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