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: 7
Default Passing a value from one userform to another (multiple) form

I have two userforms, form A and form B. Form A contains 10 textboxes
(txtbox1, txtbox2, ..., txtbox10), and form B contains a combobox and an OK
button.

What I want to achieve is as follow: whenever the user click one of the ten
textboxes if form A, form B will show. The user then select one value from
the combobox, click OK, and the selected value will be sent to the textbox
that was clicked initially. How do I make form B to recognize which textbox
that was clicked by the user?

P.S. Obviously, it will be easier if I can replace the ten textboxes in form
A with comboboxes, and eliminate the need to have form B altogether, but
unfortunately I do not have enough space in form A to do that. Each entry in
the combobox consist of 4 numbers followed by a description, and the
textboxes in form A have just enough width to show only the numbers.
 
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
Multiple fonts in a VBA UserForm label (to make XL 95 form non-modal) Anthony Berglas Excel Programming 2 August 13th 07 05:37 AM
Passing value to userform quetion Doug Glancy Excel Programming 0 December 1st 06 09:02 PM
Passing Procuedure to Userform Nigel Excel Programming 4 September 10th 05 05:22 PM
Passing variables between Sub and Userform jose luis Excel Programming 8 July 22nd 05 05:20 PM
passing control value from one form to another form mark kubicki Excel Programming 1 April 3rd 04 01:27 AM


All times are GMT +1. The time now is 07:40 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"