Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Hisham Younis   on Nov 24 In MS Office Category.

  
Question Answered By: Daisy Phillips   on Nov 24

I am very grateful for your response, which I tried, but
unfortunately it still isn't working . . . I even tried asking for
the ListIndex values in a Msgbox and the values look to me like they
should work (i.e. if I clicked on a name down on the list, the
msgbox said that it was ListIndex 33 or whatever . . . but it still
didn't reset to that line, it still came back  to the listbox
scrolled to the top with nothing highlighted, like it has reset to
ListIndex = - 1 . . . I did try the 'repaint' and it just kicked
back an error on compiling and wouldn't run.

I don't know what I'm doing wrong. Apparently, I must have
something else in the code  interfering with that textbox  change
event, as it connects to the listbox  click event  and the 'loadrow'
sub which takes whatever is highlighted in the listbox and puts it
into the textboxes. I stepped through it using F8 line by line and
when I did that, it highlighted the correct line in the
listbox! . . . Go figure.
Why it won't work when I'm running it straight doesn't make
sense. I'm totally lost, because everything I've read says it
should work.

Maybe I've hit the "other direction" of the same problem that
Lisa was working with, so to speak. Maybe I need more guidance on
the debugging part of it . . . ? . . . or mayby I've written too
much code so it goes back over it and changes it back to listindex
= -1 . . . which is how the listbox is loaded when the form is
intialized. Or, any and all of the above in a bad combination.

How do I debug that to find out? . . . or what else might I do
to get it to work?

At this point, I'm ready to submit an application for "dumber
than a post" in case anybody needs one. Anybody know a position
that's open for that, let me know. I'm probably missing something
obvious, but heck . . . it's a good thing that life is full of
variety.

And I've tried to recode it so many times, I really think that
someone smarter than I am needs to give me a new start to work
from. If I posted my present code now, I don't even know what was
the original nor what was one of the suggested . . . all I know is
that none of them worked.
I do hope someone laughs about this . . . I could use a "humor
is the best medicine' kind of laugh.

Share: 

 

This Question has 20 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on 2003 - Setfocus on userform Or get search suggestion and latest updates.


Tagged: