+ Reply to Thread
Results 1 to 12 of 12

enter into combobox if item issued msg issued in textbox

  1. #1
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    enter into combobox if item issued msg issued in textbox

    Please Login or Register  to view this content.
    i have a combobox that looks at a sheet and populates it with data ,if item is already issued a textbox appears with issued in it and after 5 secs the combobox clears and lets you enter another item , it works apart from if combox1=sheets3 "p" msg issued else is in red so something amiss although as said it works.any ideas please
    colin

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: enter into combobox if item issued msg issued in textbox

    what does "p" refer to ? - upload your workbook - see big yellow banner - far easier then to give you an in-context solution.
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

  3. #3
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    Re: enter into combobox if item issued msg issued in textbox

    hi shhet3 collumn p is issued ,if this is issued then textbox 172 will say issued for 5 secounds
    if its enmpty then it will populate combobox1 ,as said it works its just in red
    colin
    Attached Files Attached Files

  4. #4
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: enter into combobox if item issued msg issued in textbox

    OMG, help me to help you - among the maze of 23 UserForms - to save me time searching can you tell me which form to look at ?

  5. #5
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    Re: enter into combobox if item issued msg issued in textbox

    frmissued textbox is top left thanks
    colin

  6. #6
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: enter into combobox if item issued msg issued in textbox

    on what UserForm number ???????

  7. #7
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    Re: enter into combobox if item issued msg issued in textbox

    its at top of screen frmissued along with frmret all other userforms are at the bottom
    colin

  8. #8
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: enter into combobox if item issued msg issued in textbox

    Sorry, I give up, I cannot find TextBox172, it has been a long day for an old man, give me a clue what is the actual UserForm number.

  9. #9
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    Re: enter into combobox if item issued msg issued in textbox

    hi
    this is how i get to it ,open rigging register /enable editing/right click on sheet1 at the bottom of page/view code/lists all forms sheets ect down the left of screen /frmissued is at the top of list all other userforms at the bottom/double click frmissued/textbox172 is first box that is blue and has issued written on it/double click and it shows code some of it in red/as said before it does work but its in red so something wrong/if you want to run it
    userform1
    click issue of rigging gear
    enter name in dropdown box/click next
    click on top red combobox and select 526 textbox and press enter it flashes to say it has already been issued /if you try 426 it populates the screen
    as said it works but my coding is not right
    hope this helps ,you may have to enable content as sometimes turns macros off
    thanks colin

  10. #10
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: enter into combobox if item issued msg issued in textbox

    I have disabled the workbook event so that I get direct access to the code with minimum effort.
    There is nothing in the TextBox_Change event that would work - the reason the textbox is showing is that ComboBox1_Exit event is firing the TextBox172 to be visible for 2 seconds.
    I am trying to envisage what you are trying to acheive with the TextBox_Change event as their is no change taking place to fire an event.
    If the intention is to show a message box then this should follow the timed event in the relative ComboBox code.
    The search routine in the ComboBox has already checked range "O:O" (barcode) is present in the issued sheet - if the part has no barcode this check would fail - alter the range in the search to "P:P" and check this is "ISSUED"
    The series of textbox checks is not necessary - also the use of textboxes for the purpose of just holding a word is inappropriate - use Labels.

  11. #11
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    Re: enter into combobox if item issued msg issued in textbox

    hi
    ok will have a look at it tonight again and maybe look at the label instead of textboxes ,im still learning bout comboboxes ect
    thanks colin

  12. #12
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    Re: enter into combobox if item issued msg issued in textbox

    hi
    i think i get it i now think what is wanted is combobox2 to look at combobox1 to see if barcode is the same ,if it is you can not enter that barcode ,i am looking at it wrong because i can use all the comboboxes on frmissued but if i select 526 barcode in combo1 and try and select 526 in cobo2 it will say issued but if i put another number in say 417 i can actually enter that number in all remaining boxes which is not how it should work ,if i put 417 in combox3 and try to put 417 in combo5 it should say issued ,think the problem is that it does not save entries untill the form is filled and not each indiviual line whereas the combobox below would pick it up
    colin

+ 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] Issued - Returned - Outstanding Resilts
    By ArchGIS in forum Excel General
    Replies: 13
    Last Post: 05-20-2019, 11:24 AM
  2. Replies: 15
    Last Post: 08-10-2017, 06:58 AM
  3. Replies: 0
    Last Post: 04-10-2017, 01:18 AM
  4. [SOLVED] Receipts issued and record of payments
    By Marianne Rachmann in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-30-2012, 08:11 AM
  5. Count annual issued items
    By ali husain in forum Excel General
    Replies: 5
    Last Post: 12-28-2008, 03:09 AM
  6. Calculating units issued
    By Gerry1206 in forum Excel General
    Replies: 1
    Last Post: 06-21-2008, 10:57 AM
  7. [SOLVED] Can software be downloaded to my laptop from CD issued with my n.
    By LDJinLA in forum Excel General
    Replies: 8
    Last Post: 01-20-2005, 03:19 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