Posted to microsoft.public.excel.programming

Tom Ogilvy Tom Ogilvy is offline

external usenet poster

Posts: 27,285

Textbox ControlSource Property - Excel 97

textbox1.ControlSource = Worksheets(2).Range("B1").Address(External:=True)

--
Regards,
Tom Ogilvy

"Bill" wrote in message
...
Looking for the correct syntax for the ControlSource Property.

Currentl syntax is: textbox1.ControlSource = Worksheets(2).Range("B1")

This however produces the error Run-time Error 380, Could not set
property, invalid property value.

Thanks in advance for your help.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
last piece of the puzzle...controlsource in textbox	bruce forster	Excel Programming	2	April 19th 04 10:45 AM
Problem with TextBox & ControlSource - Please Help	[email protected]	Excel Programming	8	January 14th 04 06:45 AM
Controlsource	David Coleman	Excel Programming	5	December 28th 03 01:14 PM
ControlSource Compatibility VBA - VB6	John M[_4_]	Excel Programming	2	October 19th 03 05:30 PM
ControlSource problem	Christy[_2_]	Excel Programming	1	August 28th 03 03:44 AM

All times are GMT +1. The time now is 02:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us