Results 1 to 8 of 8

How to check in column and if different prompt user and restrict users?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-08-2023
    Location
    Singapore
    MS-Off Ver
    365, 2021
    Posts
    113

    Exclamation How to check in column and if different prompt user and restrict users?

    Currently, i have an column with an drop down i would like that for when user select different row if the user select in that column something not compatible it will prompt the user that this is not allow and restrict the user for adding in or typing in till they reselect the drop down, in vba

    I have make an example Marco workbook where my category i have an drop down list, user are allow to select the same name however, 3G and 4D are not allow to be selected when 4D is selected, it will prompt the user that this is not allow and restrict the user for doing anything next, so how can i do this in VBA ?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Check range of cells in column if not null/empty then restrict save and show message
    By gmalpani in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2020, 09:25 AM
  2. Check cells for blanks then prompt user
    By papasmurfuo9 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2013, 05:09 AM
  3. Prompt for password after selecting from dropdown, also restrict data
    By balaji3081 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-11-2013, 04:41 PM
  4. Macro to prompt user to check Subject when send button is clicked
    By hotmailliw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2013, 10:01 AM
  5. Excel VBA to generate check boxes and restrict user to tick on the 3 boxes in a row
    By rhodalynn.rona in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2012, 05:55 AM
  6. Finding duplicates in a column, prompt user then delete the current one
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 01-23-2012, 08:24 PM
  7. [SOLVED] restrict users
    By Restricted user access for exel workbook in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-15-2006, 11:30 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1