First up Hi people. I have been having some success with using vba forms to write to a table. My next task that im seeking assistance with is.
I have a Form with 2 Comboboxes
Id like to be able to achieve the following
select item in first combo box in userform based on column in MTable (done)
write entry to table (not sure how to do this and stay in the procedure/userform for next step)
MTable calculates range and shows it in a column cell for second combobox (this table is already created and called MTable)
second combobox reads the range from the table cell and displays range items accordingly
The calculated range for the second Combobox is in the 7th column of MTable
hope this makes sense.
I have a Form with 2 Comboboxes
Id like to be able to achieve the following
select item in first combo box in userform based on column in MTable (done)
write entry to table (not sure how to do this and stay in the procedure/userform for next step)
MTable calculates range and shows it in a column cell for second combobox (this table is already created and called MTable)
second combobox reads the range from the table cell and displays range items accordingly
The calculated range for the second Combobox is in the 7th column of MTable
hope this makes sense.
Last edited: