Search results for query: *

ETID, thanks for this suggestion. This is exactly what I was looking for. I would have like to do this without VB code. But, I think this was the only way to go. Chris

No, I mean as in your example to expand it to have several columns with different "sets" of information. My first thought is to use the column property to test what column the user is in and then use your example code with the appropiate named fields, ranges for the selected column...

A BIG Thanks ETID for the pointer and link.. This will work fine. Do you have any suggestion for expanding this to other columns? Your example fires whenever something is changed in the worksheet. Is there a method to tigger other subs (to swap values) if there are a series of columns with...

Data validation using LIST brings back a "named" range of values. This is one way to "select" a value to place into the cell. My list of "values' are text strings that can be long and difficult to read. What I would like to do is to offer the user a abbreviated text...

It's working -- ignore the error. I tried to run my code from a sub routinue.

I tried your solution and get an error message "object required." I'm wrong somewhere in setting up the Target.address. Another hint? Thanks for your quick reply and assistance. Wally

I want to run code when the user selects (moves on to) a cell in Excel. I have tried testing the active cell to determine if it matches my criteria (cell) but have not found the proper syntax. I know this must be simple... Please excuse my stumble. Any help in directing me to a helpful...

Thanks Nick for the tip.. I tried using the RecordSource property and modified the code a little and it worked: Dim strSQL As String strSQL = "SELECT * FROM [tblMain] WHERE RecordNumber = " & varIndex & "" Dim strNewRecord As String strNewRecord = (strSQL)...

There are several disscussion on using cobo boxes to change information viewed in a form. In my case, I'm using a pop-up form (with a cobo box) to retrieve a record number. I can successfully pass this value to the form. However, I'm stumped on how to change the current record to a different...