I made a sheet with a column containing a dropdown (which I now can't
find to change, but it still drops and allows selection) which has a
list of destinations. When a destination is chosen, code populates the
next column with the mileage from my house to the target.

When I cleared out last years mileages, I somehow disconnected the
code, and it no longer fires.

When I try to run it from the VBA editor, it wants a macro name.

Any suggestions for hooking it back up? I've probably described this
poorly. Can you tell I'm a newbie?

TIA, Mike

Hard to tell without seeing. If desired, send the file to my address below
along with a snippet of this msg and clear instructions of what you need.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MikeR" wrote in message
...
I made a sheet with a column containing a dropdown (which I now can't find
to change, but it still drops and allows selection) which has a list of
destinations. When a destination is chosen, code populates the next column
with the mileage from my house to the target.

When I cleared out last years mileages, I somehow disconnected the code,
and it no longer fires.

When I try to run it from the VBA editor, it wants a macro name.

Any suggestions for hooking it back up? I've probably described this
poorly. Can you tell I'm a newbie?

TIA, Mike

Don Guillett wrote:

Hard to tell without seeing. If desired, send the file to my address
below along with a snippet of this msg and clear instructions of what
you need.


Don said:

Your code could NEVER have worked since your worksheet event was not
in the sheet module and you were using a selection event instead of a
change event and there was no user form and your select was improperly
done........
Several ways to do this. One use a proper change event with a proper
select case or a VLookup in the macro or just a simple VLookup. In any
case I would put the list and numbers on another sheet so that the
list is not compromised when you delete rows.

BTW, I do custom excel programming @$75 hourly.
================================================== ====================
Don -
Thanks for taking a look. I can tell you with 100% certainty that at
one time, when an item was selected from the drop down, the adjacent
column was populated with the mileage. Why it doesn't now was the
whole purpose of my post.

Sorry, I'm too green to have the vocabulary to understand your
suggestions.

I'm not at all interested in paying you $75 an hour for programming.
This is just a little learning exercise for me.

All three of the examples I provided on your workbook worked to do as you
desire. I mentioned this in the private message (with the corrected file)
which you replied to here. Good luck.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MikeR" wrote in message
...
Don Guillett wrote:

Hard to tell without seeing. If desired, send the file to my address
below along with a snippet of this msg and clear instructions of what you
need.


Don said:

Your code could NEVER have worked since your worksheet event was not in
the sheet module and you were using a selection event instead of a change
event and there was no user form and your select was improperly
done........
Several ways to do this. One use a proper change event with a proper
select case or a VLookup in the macro or just a simple VLookup. In any
case I would put the list and numbers on another sheet so that the list is
not compromised when you delete rows.

BTW, I do custom excel programming @$75 hourly.
================================================== ====================
Don -
Thanks for taking a look. I can tell you with 100% certainty that at one
time, when an item was selected from the drop down, the adjacent column
was populated with the mileage. Why it doesn't now was the whole purpose
of my post.

Sorry, I'm too green to have the vocabulary to understand your
suggestions.

I'm not at all interested in paying you $75 an hour for programming. This
is just a little learning exercise for me.

Don Guillett wrote:
All three of the examples I provided on your workbook worked to do as
you desire. I mentioned this in the private message (with the corrected
file) which you replied to here. Good luck.

Don -
My apologies and my thanks.

I didn't get that you had done up the 3 sheets, and so I didn't open
the workbook.

I don't understand how any of the 3 work, but I can dig into the books
again in a few weeks.

How did you un-hide the col with the names in it? I couldn't get to it.

I wondered why I sent it?
Try going to the help index and typing in
unhide column
When all else fails, RTFM
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MikeR" wrote in message
...
Don Guillett wrote:
All three of the examples I provided on your workbook worked to do as you
desire. I mentioned this in the private message (with the corrected file)
which you replied to here. Good luck.

Don -
My apologies and my thanks.

I didn't get that you had done up the 3 sheets, and so I didn't open the
workbook.

I don't understand how any of the 3 work, but I can dig into the books
again in a few weeks.

How did you un-hide the col with the names in it? I couldn't get to it.