+ Reply to Thread
Results 1 to 7 of 7

reactivate combobox aftrer invalid entry

  1. #1
    Forum Contributor Axmed.cm's Avatar
    Join Date
    02-05-2015
    Location
    Somalia
    MS-Off Ver
    2013
    Posts
    231

    reactivate combobox aftrer invalid entry

    Dear All

    I am having userform with combobox1.
    If invalid enrty is inserted msgbox pops out "invalid intry" then the cursor pointer jumps to the next textbox.
    I want the cursor pointer to remain the combobox after invalid entry, so as it is easy to correct the entry at once.
    Can anyone help me do so.
    thanks
    I

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: reactivate combobox aftrer invalid entry

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Contributor Axmed.cm's Avatar
    Join Date
    02-05-2015
    Location
    Somalia
    MS-Off Ver
    2013
    Posts
    231

    Re: reactivate combobox aftrer invalid entry

    Quote Originally Posted by mehmetcik View Post
    Please Login or Register  to view this content.
    Dear

    I was using this code
    Please Login or Register  to view this content.
    and thiis is your suggestion:
    Please Login or Register  to view this content.
    I tested and I if I am not wrong I think nothing changes.
    Thanks
    GUURE

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: reactivate combobox aftrer invalid entry

    you might not see a chnge

    it is not like a textbox where you can see a cursor

  5. #5
    Forum Contributor Axmed.cm's Avatar
    Join Date
    02-05-2015
    Location
    Somalia
    MS-Off Ver
    2013
    Posts
    231

    Re: reactivate combobox aftrer invalid entry

    Dear Mehmetcik

    Thank you for your time and help.

    Let me clearly tell you what I need.

    When I click "tab" while combobox1 has valid entry the next form control is selected but if combobox1 has invalid entry I need after warning message the combobox1 is selected again (Not the next form control).

    Now it selects the next control whether combobox1 entry is valid or not, and that is what I need to to be solved.

    Thanks

  6. #6
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: reactivate combobox aftrer invalid entry

    Without your sample I cannot test anything.

    In your scenario what you would do is use the enter event of the next control

    Check if the ComBobox entry is Valid, if not do something else. Possibly select the first entry in the combobox which is a blank or a default.

  7. #7
    Forum Contributor Axmed.cm's Avatar
    Join Date
    02-05-2015
    Location
    Somalia
    MS-Off Ver
    2013
    Posts
    231

    Re: reactivate combobox aftrer invalid entry

    Thanks

    That is very helpful trick.
    I did it in next control and working good.
    thank you and here u r a reputition.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Userform ComboBox Issue - Invalid Property Value
    By Tooley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-25-2016, 12:52 PM
  2. not allowing invalid date in combobox
    By NJH88 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2013, 10:09 AM
  3. [SOLVED] userform invalid property value only on certain items in combobox
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2013, 06:30 AM
  4. Message for invalid entry
    By LilyLove in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-26-2013, 08:42 AM
  5. Combobox returning invalid property error
    By duckboy1981 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2009, 05:24 AM
  6. [SOLVED] Why are macros running slow aftrer being switched to XP?
    By dave in forum Excel General
    Replies: 1
    Last Post: 08-21-2006, 12:20 PM
  7. How to validate and -if invalid- undo an entry?
    By serdar in forum Excel General
    Replies: 1
    Last Post: 06-11-2005, 01:05 PM

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