| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
fill userform textbox from userform listbox clik event
I have a userform1 with a listbox1 (3columns) and 7 textboxes (1-7)
the listbox is filled with info from columns Q,R,S on worksheets("database") with ListBox1_Click() I want the textboxes to fill with corresponding data on same row Textbox1 = column I Textbox2 = column J Textbox3 = column K Textbox4 = column D Textbox5 = column E Textbox6 = column AA Textbox7 = column AB can anyone help? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
fill userform textbox from userform listbox clik event
how can i get the row number of what was clicked in the listbox?
"GregJG" wrote: I have a userform1 with a listbox1 (3columns) and 7 textboxes (1-7) the listbox is filled with info from columns Q,R,S on worksheets("database") with ListBox1_Click() I want the textboxes to fill with corresponding data on same row Textbox1 = column I Textbox2 = column J Textbox3 = column K Textbox4 = column D Textbox5 = column E Textbox6 = column AA Textbox7 = column AB can anyone help? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
fill userform textbox from userform listbox clik event
'Cross posting' (http://tinyurl.com/6lhfvt) -- royUK Hope that helps, RoyUK For tips & examples visit my 'web site' (http://www.excel-it.com/) ------------------------------------------------------------------------ royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=38039 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
fill userform textbox from userform listbox clik event
I've already shown you in the other Forum -- royUK Hope that helps, RoyUK For tips & examples visit my 'web site' (http://www.excel-it.com/) ------------------------------------------------------------------------ royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=38039 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UserForm initialize event run when UserForm is shown | Excel Programming | |||
| Userform - with Commandbutton fill a Listbox with data.. | Excel Programming | |||
| Fill a Listbox with mult. Variables in userform | Excel Programming | |||
| userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
| What event to detect click on UserForm ListBox? | Excel Programming | |||
![GregJG[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
