PDA

View Full Version : How to pass combobox/textbox selected member into sql string in main module



yingchai
10-28-2012, 06:48 AM
Hi VBA gurus,

I have this VBA macro which contains some combo boxes and text boxes. The code is at the ThisWorkbook under Excel Objects. My main VBA code is programmed at the Module1 under Modules folder.

My question is how can I passed the selected combobox/textbox member into thet sql string at Module1? I attached the VBA macro here.

Kindly advise.