Im using VBA build inside excel
is there a way to find if ComboBox has a value?
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.
You 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 that you have an array of 80 combo's
Range("S8") = "0.12"
Elseif cmbMyBox(i).Text = "" Then
Exit Sub ''Exit and do something...
i am trying to create a library management system which is supposed to be used to store/keep infp for the library and the library members( book title, author, name and picture for borrower and other stuffs). The app has 6 buttons, delete, save, add,previsous,next, and upload( for upload ...