Closed Thread
Results 1 to 3 of 3

data validation and formula in same cell

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

    Angry 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?


    [ATTACH]737714

    Book6.xlsx
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 06-24-2021, 12:30 PM #2
    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
    48,439

    Re: data validation and formula in same cell

    Well, you can't have it but why do you need it?
    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
  3. 06-24-2021, 12:31 PM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,972

    Re: data validation and formula in same cell

    Administrative Note:

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-pro...same-cell.html
    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
Closed 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 Sybon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-25-2021, 06:35 AM
  2. Data Validation and formula in same cell
    By VisionSmart in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-04-2019, 03:47 AM
  3. 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
  4. 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
  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