Results 1 to 3 of 3

Thread: Mandatory cell input with drop down menue

  1. #1
    Join Date
    Apr 2012
    Posts
    2

    Mandatory cell input with drop down menue

    Hello all,

    I know there have been posts about mandatory cell input. So far, I haven't found a solution to my problem, though.

    I have a dropdown menue in column L. If the user chooses a certain value of the dropdown menue, I want him to fill in the cell in column M, too.

    How can I do this?

    Thanks,
    Hermann

  2. #2
    Join Date
    Jul 2011
    Posts
    623

    Re: Mandatory cell input with drop down menue

    I have a solution for that if you are using Microsoft Excel. For adding the same value of drop down cell to another you need to type "=L3". Here = is the begining syntax and L3 is the cell address which has drop down list. Once a user choose a value of drop down box, the same value is reflected to the cell where you had added this formula.

  3. #3
    Join Date
    Apr 2012
    Posts
    2

    Re: Mandatory cell input with drop down menue

    Thanks for your reply.
    I needed them to fill out column M with different data, though. But I've found a solution already (VBA).

Similar Threads

  1. Lock drop down cell in Microsoft Excel
    By Thedevotee in forum MS Office Support
    Replies: 2
    Last Post: 15-02-2012, 05:48 PM
  2. How to make a Cell input Mandatory in Excel
    By hanni ball in forum MS Office Support
    Replies: 4
    Last Post: 01-02-2012, 07:05 PM
  3. How to change cell color in excel based on text input
    By Chini mao in forum Windows Software
    Replies: 2
    Last Post: 06-01-2012, 09:19 PM
  4. Replies: 3
    Last Post: 14-12-2011, 11:13 AM
  5. Input based drop downs in Word 2010
    By gautambangalore in forum Windows Software
    Replies: 1
    Last Post: 23-08-2011, 05:46 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,627,483.07270 seconds with 17 queries