Input Box

N

Nick Hodge

Right click on any toolbar and select Control Toolbox.
Select a textbox from here and show the properties window
(this is the hand holding the bit of paper). Edit
the 'LinkedCell' property, eg Sheet2!D1

Now exit design mode, (the triangle button) and anything
you enter in the text box will be displayed in Sheet2!D1

HTH
Nick Hodge
MVP - Excel
-----Original Message-----
I am trying to insert a textbox into excel and link the
Click to expand...
number that is entered to another cell. The textbox on
the forms toolbar is greyed out and I am unable to get the
textbox in the control toolbar to work. I can insert it
into excel and adjust the settings but it never allows me
to enter a value. I am trying to use the forms textbox
since I don't want to sue VBA and Macros. How do I do
this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text Box event to tab to next text box 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Combo box 0
userform exception error 4 textboxes 7
ActiveX control text box 0
Writing code to objects within MultiPage object 2
TextBox Autosize 0
Changing Bound Text Box Border Width Property Screws Up Tab Order 0

Top