Working With Checkbox in VBA Excel
Posted on 2011-03-06
I have four checkboxes in my VBA excel application which are as follows
I will be using this checkboxes to form an query to a database,
If the user selects all the checboxes, then the query that i am looking for should be like,
" ' 1 - Show Stopper' Or '2 - High' Or '3 - Medium' Or '4 - Low' "
How can i form this query line through the selection of checkboxes
Please help with the coding, if you want i will change the caption of checkbox as 1 - Show Stopper' and as follows to form an query at last try only.