Excel Lookup Data from Combo box

[Hap007]

Hi,

I have done a good deal of VB and VBA work in Access and VB, but not sure how to handle these same tasks in Excel.

I have managed to add buttons and controls in Excel and have located the code. Now I need the help.

I want to have a combo (Drop down) control lookup a job number in a remote MS Access table.

Once I have done that lookup, I want the value placed in a certain row.

The rows are for different times of the day, and the column is Job Number.

Any suggestions on getting this done?

Is there a way to double click on a cell and the lookup becomes visible and I can select a value?

I need the same lookup to fill and one of the 24 columns, based on which row the user is currently positioned.

Is this possible in Excel?
If so, any suggestions on how?
Should I use a Control on the datasheet or should I use a Form?

Thanks,
Hap...


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[SkipVought]

Hi,

How often do Job Numbers get added/deleted from your Access DB?

I'd probably use Data > Import External Data... to ADD a querytable to an empty sheet to return the Job Numbers. I would NAME the range of return values on that sheet.

On your main sheet, use Data > Validation - LIST in the cells where you want to select a Job Number, referencing the Range Name of the return data.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[Hap007]

Hi,


Id there any way I can link the Access data to the Lookup.

This data 'Job Numbers' will be added to during the day, so you never will know if you are looking at the most current data if you rely on an import.

Thanks,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[SkipVought]

You have posted in the MS Office forum. Therefore, I am suggesting Office functionality.

The QueryTable can have a switch set to refresh every x minutes

If you want a code solution, you'll need to ask in Forum707.


Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}