Drop Down/Combo List qestion

[supanoods]

Hi guys,

I am currently working on an excel program that looks at personnel details. I have one worksheet that has names, addresses, etc and another that is a nice user-frienly front end type of screen.

On the user screen, I have added a drop down list and set the entries to a named range on the data sheet, which when a name is selected - a series of vlookups pick up the matching address deatils.

The question is - I would like to have a blank screen at startup of my program - any ideas how to do this other than create a blank entry in my data range?????

thanks in advance!

Cheers, Supanoods B-)
"If it aint broke - dont fix it!

 

[Rofeu]

Hi,

just clear the value of the cell with the dropdown list upon saving, i.e

(name the range/cell DropDownCell)

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
with Range("DropDownCell")
  .Value = vbNullString
  .Parent.Calculate
End With 
End Sub

Cheers,

Roel

 

[supanoods]

Thanks for your reply but unfortunately this won't work, because the drop down i'm using is a physical control (like a combo on a form only on the worksheet).

apologies if I didnt make it clearer in my first post!

Cheers, Supanoods B-)
"If it aint broke - dont fix it!

 

[Rofeu]

ok, so, I assume that your vlookups use the value in the linkedcell.....

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
with Range("LinkedCell")
  .Value = vbNullString
  .Parent.Calculate
End With 
End Sub

Cheers,

Roel