Changing the height of a commandbar control (edit box) at runtime

  • Thread starter Thread starter simon livings
  • Start date Start date
S

simon livings

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
 
Simon said:
(I am starting to think this can't actually be done).
Click to expand...

I think you are right.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
 
Back
Top