LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
UserForm initialize event run when UserForm is shown [email protected] Excel Programming 2 June 13th 07 02:49 AM
Userform - with Commandbutton fill a Listbox with data.. Arjan[_2_] Excel Programming 1 September 9th 06 07:24 PM
Fill a Listbox with mult. Variables in userform Jennifer Excel Programming 2 May 23rd 06 07:28 PM
userform listbox cannot get listbox.value to transfer back to main sub [email protected] Excel Programming 1 May 17th 06 09:44 PM
What event to detect click on UserForm ListBox? Don Wiss Excel Programming 1 August 26th 05 10:35 PM


All times are GMT +1. The time now is 02:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"