Im using VBA build inside excel
is there a way to find if ComboBox has a value?
for example
i have 80 ComboBox and i want to check if they have a value like "A", "B", "C" and "D"
and if the value is blank like "" then stop the checking.
ImZick
0
Posting Whiz in Training
Recommended Answers
Jump to PostYou are almost on the right track. :) Try the following...
Public Sub Test() Dim cmbMyBox As ComboBox ''Do Not use ComboBox, it is a reserved name for ... combobox Dim i As Integer For i = 1 To 80 If cmbMyBox(i).Text = "Level 4" Then ''Assuming …
All 3 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.