Posted to microsoft.public.excel.programming

TDC

external usenet poster

Posts: 14

If then to hide a combo box

I am trying to make a combo box appear if a value is greater than 1 or hide
if it is not. Below is what I have, but it does not work. Suggestions?

Private Sub test_change()
If Range("AJ19").Value 1 Then
UserForm1.ComboBox1.Visible = True
Else
UserForm1.ComboBox1.Visible = False
End If
End Sub

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
hide combo box	JD	Excel Discussion (Misc queries)	6	February 17th 09 06:34 PM
Hide Combo Box	Troubled User	Excel Programming	4	October 31st 06 01:08 PM
Hide Combo Boxes	AJ	Excel Worksheet Functions	0	October 11th 06 04:22 AM
Hide my combo boxes!	hays4	Excel Discussion (Misc queries)	6	November 7th 05 02:45 PM
Combo Box - Hide Combo Box w/Check Box	Paul	Excel Programming	5	December 3rd 04 10:58 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us