Posted to microsoft.public.excel.programming

cody

external usenet poster

Posts: 71

Can anyone see the problem with this code?

Sub DropDown1_Change()
If Sheets("Sheet1").Range("C62") = 3 Then
TextBox1.Visible = False
Else: TextBox1.Visible = True
End If
End Sub

The debugger say "Object Required" and highlights the Else line.

Thanks

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
Code problem	Ruben	Excel Discussion (Misc queries)	4	August 26th 08 08:22 AM
XLS to CSV Code Problem	carl	Excel Worksheet Functions	0	March 28th 07 01:21 AM
VBA Code Problem	Shawn	Excel Programming	9	July 19th 05 04:48 AM
Problem with the following code	Vince	Excel Programming	3	November 19th 04 08:51 AM
Code problem	Rick[_11_]	Excel Programming	1	August 8th 03 04:25 AM

All times are GMT +1. The time now is 07:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us