Forms Toolbar Programming
 

I have an excel spreadsheet with many drop down menus. I
have formatted each cell to print the value of the item
chosen in the drop down menu, but would like it to ONLY
print when there is an actual value there. Is this
possible? Thanks, KB

Forms Toolbar Programming
 

drop downs from the forms toolbar return the index of the selection. If you
are using another cell to display the value for the index in the linked
cell, you could use a conditional formula

linked cell is A1 for example

in B1
=if(A1=0,"",Index(A1,Z1:Z20,1))

--
Regards,
Tom Ogilvy



KB wrote in message
...
I have an excel spreadsheet with many drop down menus. I
have formatted each cell to print the value of the item
chosen in the drop down menu, but would like it to ONLY
print when there is an actual value there. Is this
possible? Thanks, KB