ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hide Combobox (https://www.excelbanter.com/excel-programming/303269-hide-combobox.html)

Lakeuk

Hide Combobox
 
Is is possible to hide a combobox based on a multipage being selected.

Thanks
Dave

keepITcool

Hide Combobox
 


Note multipage numbering is 0 based..

This will hide the combo if the 2nd page is selected
Private Sub Multipage1_Change()
ComboBox1.Visible = (MultiPage1.Value < 1)
End Sub


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


(Lakeuk) wrote:

Is is possible to hide a combobox based on a multipage being selected.

Thanks
Dave



Lakeuk

Hide Combobox
 
Note multipage numbering is 0 based..

This will hide the combo if the 2nd page is selected
Private Sub Multipage1_Change()
ComboBox1.Visible = (MultiPage1.Value < 1)
End Sub


Thanks exactly what I was looking for.

Thanks, Dave


All times are GMT +1. The time now is 09:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com