show name when a cell has specific word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
How do we add into VBA a code to insert a name into a cell when another cell
has a specific word selected from a validation list.

Any help would be appreciated.

Thanks Noemi
 
Would a formula such as =IF(B1="Fred","Barney","") work for you? (assuming
your cell to be checked to be B1)
 

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

Define a range of cells in VBA 2
update details using vba 5
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
make cell equal a word if a data validation cell has a word in it 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Deleting Code from VBA 1
Word VBA for deleting Selected Row 0

Back
Top