help with msgbox

S

shirley

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
 
H

Harish S

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
 
H

Harish S

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 said:
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
Click to expand...
 
S

Steve

Shirley
You can set the Tab Order... of the form to have your first cell highlighted, then using the required field as yes and validation rule as is not null, you will make it so they must enter the first column first.
 
Top