Forms Toolbar Programming

K

KB

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
 
T

Tom Ogilvy

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Clearing Fields in a Word Form 5
Redirect Selection in Cell to Print Job 0
Excel does not accept text format! 0
Changing Column Width Temporarily 0
list or combo box 0
Button to duplicate current forms (for an invoice) 1
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1

Top