i want to make sure that when a new line is inserted, the user ha
selected a cell under the first column first before the line i
inserted. if not, they will be prompted to do so. how should i do it

--
Message posted from http://www.ExcelForum.com

Hi,
I have a worksheet which has names and addresses in the fields. I would like
to have a VBA macro such that it provides a list of names as a list drop box
and a button that says print address.

I dont know how to have the listbox get to accept the name column as a
datasource. Any help would be appreciated.

Best,
Harish S
"shirley " wrote in message
...
i want to make sure that when a new line is inserted, the user has
selected a cell under the first column first before the line is
inserted. if not, they will be prompted to do so. how should i do it?


---
Message posted from http://www.ExcelForum.com/

Sorry. my last post should have been posted as a new one. I apologize for my
mistake and any inconvinience this has caused anyone.

Best,
Harish S
"Harish S" wrote in message
...
Hi,
I have a worksheet which has names and addresses in the fields. I would
like
to have a VBA macro such that it provides a list of names as a list drop
box
and a button that says print address.

I dont know how to have the listbox get to accept the name column as a
datasource. Any help would be appreciated.

Best,
Harish S
"shirley " wrote in message
...
i want to make sure that when a new line is inserted, the user has
selected a cell under the first column first before the line is
inserted. if not, they will be prompted to do so. how should i do it?


---
Message posted from http://www.ExcelForum.com/

no problem


---
Message posted from http://www.ExcelForum.com/