listbox click

I want to pass values from a userform to an excel table. I use an UPDATE button but it only works when i doubleclick on items of the listbox. When i use one click it doesn't work! Any ideas why?Thanks a lot in advance... ---- code for click event in listbox------- Private Sub...

Hi everyone, my name is Gil, I have this screen (Userform) with 3 Listbox (The third has been cut) that show me what is being operated on the 3 machines. I am trying to implement a routine where I click on one of the operation and open a new Userform showing the operations Information in...

Hello - I am new to posting on here but have found these forums very helpful so hopefully you can help! I am using a userform with a listbox. The listbox is pre populated. When the user selects an item from the listbox, I would like to search previous outputs (in column C) in the worksheet...

Thanks for taking the time to try and figure this one out! At my work we keep a log of companies that do work for us (particularly create drawings/schematics). We take their name and assign them a number. We call this an F#, which stands for Foreign Number (eg. F-125100-001 thru -999). What...

I have a user form with 3 questions. 1.) Thickness (this selects the correct sheet I have e.g "6-8mm", "10-12mm"). 2.) Number of defects. From question 1, this number here is inputed into the correct work sheet. 3.) Number of people. Same as questions 2; this number here is inputed into the...

Hello everyone! Hopefully you can help me with this and I'm just missing something really simple :nya: I'm having an issue with a worksheet I have pasted into a PowerPoint slide using Paste Special>Paste Link>Microsoft Excel Worksheet (code) Object. The trouble is in the worksheet I have a...

Hello folks, May be the question i m posting is very much simple and easier task, however i m finding the same from last many days but couldn't seems any results. I have attached the snapshot of the form where i m retreiving the access table data in the excel userform listbox. Now i would...

Good, bleary-eyed, morning folks, Today's conundrum is that using Range.Delete(xlUp) is causing unexpected _Click events (two in fact) in a ListBox. I have a named range, "List", covering $A$3:$A$7 which is used in the box's ListFillRange property and as data in the Sub UpdateList. A second...