bdsii
02-23-2011, 12:50 PM
I have not been able to figure this one out and am hoping someone here can move me in the correct direction.
I have a spreadsheet where data will be pasted daily and each day the number of rows of data will differ. The data covers Columns A through D. I am then processing that data with VBA with no problem.
What I cannot figure out is how through VBA only to create a combo box in Column E for each row of data present that day. I have the code to populate the combo box, I think, I just do not know how to create the combo box through VBA and specify that each row with data will get a combo box. The selected value from the combo box could be different for each row which is why I need a specific combo box that is tied to each row so when I complete the process, the value selected would function just like I typed in the value selected into column E. Does that makes sense ?
Once I have the combo boxes established for each row, do I need to refer to them in the final code by the combo box name or just the same as I would any other cell location ?
thanks !
:hi:
I have a spreadsheet where data will be pasted daily and each day the number of rows of data will differ. The data covers Columns A through D. I am then processing that data with VBA with no problem.
What I cannot figure out is how through VBA only to create a combo box in Column E for each row of data present that day. I have the code to populate the combo box, I think, I just do not know how to create the combo box through VBA and specify that each row with data will get a combo box. The selected value from the combo box could be different for each row which is why I need a specific combo box that is tied to each row so when I complete the process, the value selected would function just like I typed in the value selected into column E. Does that makes sense ?
Once I have the combo boxes established for each row, do I need to refer to them in the final code by the combo box name or just the same as I would any other cell location ?
thanks !
:hi: