UserForm ComboBox RowSource Problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Greetings,

I have a set of four Frames on a UserForm. On Frame 2 is a ComboBox.
I am loading this ComboBox with one of 31 named ranges. The named
ranges are called Ref1 thru Ref31. The first Frame has a TextBox on
it called TBDay to be filled in by the user. This is how I get the
actual name for the Ref of interest. ("Ref" & TBDay.Value) This Ref
is 27 rows by 38 columns. The TBDay selects which day I need and the
ComboBox Index selects which of 27 rows I need data from. In theory,
when I choose a name from the ComboBox, the rest of the data on that
row will automatically show up in 20 TextBoxes. This is working,
almost!!! It works for the index numbers 1-27(0 is the first item and
NOT working). I have a zipped sample which uses only two days not 31.
But the problem shows up when going up or down in either of the two
days of the sample. As you scroll down, you see the data in the 20
TextBoxes changing as they should. As you scroll up it also changed
until you get to the second item in the list (It doesn't matter which
list day 1 or day 2). As you go from the second item to the first
item the 20 TextBoxes continue to show the contents of the SECOND row,
not the first!!!!.

Anyone have any ideas as to what is going on?

If it makes it any easier, I can send my zipped sample. Just send me
an email with a return address requesting the sample and I will be
happy to send it.

Thanks

-Minitman

.

Relevant Pages

  • RE: Show Results in TextBoxes, ONLY if All TextBoxes have Data in
    ... as in check the textboxes. ... Dim tbEmpty As Boolean ... Private Sub CommandButton1_Click ... ComboBox are blank. ...
    (microsoft.public.excel.programming)
  • RE: Interactive chanage of combo box with synchronized value change in
    ... how do you populate your combobox, ... the textboxes and combobox on one form ... ... customer, the txtaddress to display the corresponding address, etc. ...
    (microsoft.public.fox.vfp.forms)
  • Re: How to import certain fields from access database?
    ... what will be the code for importing fields into from/word from access? ... Then if the use types the word into the combobox, ... from the database, e.g. have a textbox where user types in cust. ... i made a form using ms word 2003 vba with few textboxes, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Combobox height
    ... form not the frame. ... wrong scale mode and for everything to go haywire. ... Public Sub SetComboHeight(ByVal Combo As ComboBox, ... L = ScaleX(Combo.Left, Combo.Parent.ScaleMode, vbPixels) ...
    (microsoft.public.vb.general.discussion)
  • Multipage form - Help
    ... >to show the value corrosponding to combobox value. ... >2) How to populate the two textboxes w.r.t. combobox ... For each set of constants in tab1, ... >Tab1 and tab2 boxes to be cleared when user clicks on ...
    (microsoft.public.excel.programming)