Thread: Text Box Macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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?