+ Reply to Thread
Results 1 to 7 of 7

data validation and formula in same cell

  1. 06-23-2021, 02:06 AM #1
    Sybon
    Sybon is offline
    Registered User
    Join Date
    08-23-2020
    Location
    Dhaka
    MS-Off Ver
    2016
    Posts
    23

    Lightbulb data validation and formula in same cell

    Hi Wizards,
    Hope you are doing well. COuld u please help me to use data validation and formula in the same cell?


    Book6.xlsx

    e2.JPG
    Reply With QuoteRegister To Reply
  2. 06-23-2021, 02:21 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: data validation and formula in same cell

    Why would you need Data Validation? All options are covered by your formula ?
    Reply With QuoteRegister To Reply
  3. 06-23-2021, 04:42 AM #3
    Sybon
    Sybon is offline
    Registered User
    Join Date
    08-23-2020
    Location
    Dhaka
    MS-Off Ver
    2016
    Posts
    23

    Re: data validation and formula in same cell

    Hi..
    Thanks for your reply. It was an example. I need it for another project just for automatic or manual entry from a user. Could you please help me?
    Reply With QuoteRegister To Reply
  4. 06-23-2021, 04:44 AM #4
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: data validation and formula in same cell

    Looks like you'll need VBA. Perhaps ask a mod to move your thread to the proper forum ?
    Reply With QuoteRegister To Reply
  5. 06-24-2021, 12:47 PM #5
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,464

    Re: data validation and formula in same cell

    As I said in the other thread, well, you can't have it but why do you need it?

    You should quote the example you DO want addressing, not a simplified example.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  6. 06-25-2021, 06:31 AM #6
    Sybon
    Sybon is offline
    Registered User
    Join Date
    08-23-2020
    Location
    Dhaka
    MS-Off Ver
    2016
    Posts
    23

    Re: data validation and formula in same cell

    Please have a look at the ink.

    https://www.loom.com/share/eba3df526...eed29609e30d22
    Reply With QuoteRegister To Reply
  7. 06-25-2021, 06:35 AM #7
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,944

    Re: data validation and formula in same cell

    Attach the workbook directly here - there are instructions at the top of the page. NOBODY needs to have to follow a link in order to help you!
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Data Validation and formula in same cell
    By VisionSmart in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-04-2019, 03:47 AM
  2. Formula drops in a cell w/ Data Validation
    By donyadaniels76 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-26-2016, 08:02 PM
  3. Data Validation - Formula in Cell Not allow any changes
    By loverfellow in forum Excel General
    Replies: 2
    Last Post: 11-11-2015, 10:15 AM
  4. Data Validation against cell where value is derived from a formula
    By brian_2me in forum Excel General
    Replies: 1
    Last Post: 04-14-2014, 04:53 PM
  5. excel formula working on a cell which is having data in a data validation cell
    By sujithy007 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-16-2013, 04:18 AM
  6. excel formula working on a cell which is having data in a data validation cell
    By sujithy007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-16-2013, 04:05 AM
  7. [SOLVED] Using formula on a cell with data validation
    By shawnsonline in forum Excel General
    Replies: 6
    Last Post: 08-10-2012, 05:31 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1