Posted to microsoft.public.excel.programming

CR[_3_]

external usenet poster

Posts: 1

How do I set the value of a textbox on a userform to the value in a named cell?

Let's say that I have a cell named "FredCell". And I have a textbox
("textbox1") on a userform. When I activate the userform, I want the
form to display the value in "FredCell" in textbox1. Is there anyway
to refer to the name "FredCell" without using row and column notation?

I hope this question isn't too basic, but I'm just starting out!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Userform with textbox displaying Cell B1 Value	JMay	Excel Discussion (Misc queries)	2	October 4th 09 12:56 AM
userform textbox	Phil	Excel Worksheet Functions	5	January 16th 05 06:59 PM
UserForm TextBox to ActiveSheet TextBox over 256 characters	Dan E[_2_]	Excel Programming	1	July 28th 03 07:36 PM
Help with Syntax UserForm TextBox	John Wilson	Excel Programming	1	July 28th 03 04:15 PM
Userform Textbox writing to a cell	Rich[_12_]	Excel Programming	3	July 22nd 03 02:34 AM

All times are GMT +1. The time now is 09:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us