vendredi 19 octobre 2018

How to make automatic tick on checkbox in Excel if the file is opened in Macro

I have the excel file with the comboboxes and tick boxes beside of them. What I need is to make automatic tick once I open the file.

The code of the ComboBox is:

Private Sub CommandButton1_Click() 
Dim filecsv As Variant 
filecsv = Application.GetOpenFilename(FileFilter:="Excel Files,*.csv") 
If filecsv <> False Then 
Workbooks.Open Filename:=filecsv 
End If 
End Sub

Can you please help me on this? enter image description here




Aucun commentaire:

Enregistrer un commentaire