Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default From ListBox selection labels on userform to show sheet cell valu

I have 3 Userforms; the first contains a ListBox from which user select a
specific Quotation number (column A on underlying worksheet). The first
UserForm also contains text boxes that, upon a "cmdShow" button go and get
relevant data from the row chosen by the user in the ListBox and show these
values in the textboxes on UserForm1. All fine.

On Userform2, I do not want user to have to choose Quotation number from the
same ListBox (also on Userform2) in order to populate the textboxes on
UserForm2 (different cell values from same row as User selected when on
UserForm1).

So I deleted the ListBox on serForm2 and using offsets and references back
to UserForm1 Listbox selection, can get textboxes on UserForm2 to do this -
all fine.

BUT, not if I use Labels to show cell values - Labels seem to pick up and
highlight the right column (per offset), but don't know which row to show. I
end up with a TRUE in the Label.

As I don't want users to be able to change output from cells and given the
"Enabled - False" of textboxes make reading difficult on the Userform, could
anyone help me with this?
--
Many thanks for any help you can provide!
Reply
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
Go to sheet based on ListBox selection jeff Excel Programming 4 August 10th 09 10:42 PM
Show Last Record in the Listbox when userform Loads. Shazi Excel Programming 8 July 17th 08 04:03 PM
Show A userform on selection range Sanjay[_2_] Excel Programming 4 April 19th 07 05:33 PM
Compare Cells on Sheet to ListBox Selection NNexcel Excel Programming 1 October 5th 04 06:46 PM
Capture listbox selection to a cell in a different sheet Marcie Excel Programming 2 September 19th 03 12:15 PM


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

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

About Us

"It's about Microsoft Excel"