robertmwaring2
Board Regular
- Joined
- Mar 8, 2019
- Messages
- 132
- Office Version
- 365
- Platform
- Windows
Hello All!
Thanks for taking the time to read through this. I am still a novice at VBA but have learned quite a bit through trial and error, macro recorder, and YouTube. I am trying to finish a project I started MONTHS ago now that I have a better understanding of what I am doing but have hit an issue I cannot seem to resolve. Hopefully someone can help.
I have a userform with three combo boxes and a button. The first of the three populates at form initialization, the second populates depending on data from the 1st, and the 3rd depending on information form the 2nd. When the user makes a selection form the 3rd combobox, I need to search through a table in sheet 3 in the workbook to find every instance that a cell in a specific column ([options]) that is not blank. For each time it finds a cell that isn't, I am trying to have another userform open to gather information from another dropdown to fill the cell in the column to the left of the one that called the 2nd userform. Below is the code I was super excited I worked out, at least it worked with a message box. When i replace the msgbox with userform.show I get a runtime error (424 - object required). I have no idea what that mean nor how to fix it - can someone please help??
Thanks in advance for any suggestions or assistance.
Thanks for taking the time to read through this. I am still a novice at VBA but have learned quite a bit through trial and error, macro recorder, and YouTube. I am trying to finish a project I started MONTHS ago now that I have a better understanding of what I am doing but have hit an issue I cannot seem to resolve. Hopefully someone can help.
I have a userform with three combo boxes and a button. The first of the three populates at form initialization, the second populates depending on data from the 1st, and the 3rd depending on information form the 2nd. When the user makes a selection form the 3rd combobox, I need to search through a table in sheet 3 in the workbook to find every instance that a cell in a specific column ([options]) that is not blank. For each time it finds a cell that isn't, I am trying to have another userform open to gather information from another dropdown to fill the cell in the column to the left of the one that called the 2nd userform. Below is the code I was super excited I worked out, at least it worked with a message box. When i replace the msgbox with userform.show I get a runtime error (424 - object required). I have no idea what that mean nor how to fix it - can someone please help??
VBA Code:
Private Sub menuname_Change()
For Each X In Sheet3.Range("Table1[OPTION]").SpecialCells(xlCellTypeVisible)
If X.Value <> "" Then
UFOPTION.Show
End If
Next X
For Each X In Sheet3.Range("Table1[QUANTITY]").SpecialCells(xlCellTypeVisible)
If X.Value = "QUANTITY" Then
MsgBox X.Address
End If
Next X
End Sub
Thanks in advance for any suggestions or assistance.