M
mju
I am trying to write a VBA program that will ask user to enter the company's
name in an input box.
it will then lookup an Access database to find matching company's name to
return company's ID.
ID number will be returned in an Excel spreadsheet in cell B1.Company's name
will be in cell A1.
Before Search:
Company 's name ID_Num
macy 's
After Search:
Company 's Name ID_num
macy 's 123
name in an input box.
it will then lookup an Access database to find matching company's name to
return company's ID.
ID number will be returned in an Excel spreadsheet in cell B1.Company's name
will be in cell A1.
Before Search:
Company 's name ID_Num
macy 's
After Search:
Company 's Name ID_num
macy 's 123