I am trying to hide the drop-down box "Drop1" when I select a check-box, "Checkbox1". I am new to VBA and here is the code I have got so far:
If ActiveSheet.Checkbox1.Value = True Then
Drop1.Hidden = True
Drop1.Hidden = False
However I can't get it to work, and also my VBA says that line 2 of this code is wrong. Any ideas?
Simple Excel VBA hiding objects help? Watch
- Thread Starter
- 08-12-2010 18:36
- 10-12-2010 19:27
It may be because the .Hidden property does not exist, at least not in .NET.
Drop1.Visible = False