Edit box - Excel 2002

  • Thread starter Thread starter Carl Kasper
  • Start date Start date
C

Carl Kasper

Hello NG,

I'm amazed, I do a lot with VB and sometimes use Excel but I can't figure
how to create a simple 'edit box' or 'text box' that modifies the content of
a cell.
When using the 'Form' toolbox, the spinner works but the 'Edit box' is
disabled.

Thanks for your ideas.

Carl
 
Carl,

As I understand it, those controls that are disabled are not intended as
worksheet controls, but are for dialog sheets.

There is a textbox on the Drawing toolbar that could be used, or you could
use the textbox on the ActiveX Control toolbar.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Bob, the 'Text Box' on the Drawing toolbar does not have a link property so
that the result is transferred to a certain cell. The same seems the case
for the TextBox of the Control Toolbar.

Because of macro security, I can't use any VBA code within the workbook but
dialog forms seem to build on VBA.

Some background:
I use one sheet that includes all number data. All other sheets reference
this sheet as a base for calculations. At some occasions this data needs to
be modified. Important is that the modification should not directly take
place on this data sheet but from a different more user-friendly sheet.
As mentioned, so far only the spinner control from the Forms toolbar was
able to serve this purpose. But, it just allows up/down increments instead
of actually entering a number.

Any idea.

Carl
 
Try the textbox from the control toolbox toolbar.

Place your textbox in the worksheet and make sure you're in design mode (icon on
the same control toolbox toolbar).

Then rightclick on the textbox and select properties. Look for LinkedCell.

Depending on what you need, you may want to play around with these, too:

EnterKeyBehavior to True (enter key moves to new line within the textbox)
MultiLine to True
Scollbars to 2-fmScrollbarsVertical
WordWrap to True
 
Back
Top