| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing the height of a commandbar control (edit box) at runtime
Dear all,
I have a commandbar with a control edit box. At runtime I am adding the Activecell's formula to the edit box and changing the width of the box to accommodate its length. However, if the formula goes over a certain length I would like to adjust the height of the control on the commandbar (which is floating) so that the formula can fit more appropriately. I am not having much luck at the moment - can anyone gives me some pointers? (I am starting to think this can't actually be done). Thanks in advance, Simon Livings *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing the height of a commandbar control (edit box) at runtime
Simon livings wrote:
(I am starting to think this can't actually be done). I think you are right. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Textbox added to Form at runtime too small, can't control size andchange event won't trigger | Excel Worksheet Functions | |||
| Textbox added to Form at runtime too small, can't control size andchange event won't trigger | Excel Worksheet Functions | |||
| need to dbl row height without changing height of cell next to it | New Users to Excel | |||
| How to edit row height with conditional formatting? | Excel Discussion (Misc queries) | |||
| Add control to commandbar | Excel Programming | |||
Linear Mode
