combo box and vba 
Author Message
 combo box and vba

I have a combo box in which jan-dec are the input range and cell d301
is the cell link. I like to use a vba code to view only the month
selected.

This is what I have so far but it's not working.

The combo box is assigned to the following macro. (intended to show
columnw H and I=jan)
If d301 = 1 Then
Columns("j:ae").Select
Selection.EntireColumn.Hidden = True
End If

Thanks,

Jin



Sat, 04 Jun 2005 13:33:24 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Change text box to combo box in VBA

2. Populating Combo boxes with VBA

3. Can't select item in Combo Box from VBA

4. Changing the .Visible Property on a Combo Box from VBA

5. Setting a value in a combo box in VBA

6. Combo box, with VBA

7. Combo Box in VBA vs VB

8. accessing FoxPro tables in Word Combo Box with VBA

9. VBA Combo Box, how to fill based on first combo box selection

10. Possible to set to data range of a combo box with vba?


 
Powered by phpBB® Forum Software © phpBB Group