JohnWilliams
New Member
- Joined
- Sep 1, 2008
- Messages
- 1
VBA Novice
Excel 2003
I've recorded a macro in Excel that retrieves accounting data. When recording the macro I select a specific Job number. The results are as follows:
"WHERE (MASTER_JCM_JOB.Job= '08-007')"
I would like to make the recorded Job number a variable that other users can select from a drop down list box. My attempts to do so have not been successful. I suspect the single quotes are part of the challenge.
Any assistance is appreciated
Excel 2003
I've recorded a macro in Excel that retrieves accounting data. When recording the macro I select a specific Job number. The results are as follows:
"WHERE (MASTER_JCM_JOB.Job= '08-007')"
I would like to make the recorded Job number a variable that other users can select from a drop down list box. My attempts to do so have not been successful. I suspect the single quotes are part of the challenge.
Any assistance is appreciated
