Re: TAB properties in a UserForm - Requesting Help from Excel VBA Guru
- From: "Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 22 Jul 2005 19:37:18 +0100
My simple test doesn't show that problem. Post the code.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"DNAHAWKS" <DNAHAWKS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C7ACB733-79F7-4B43-B81E-A3D7C72FF903@xxxxxxxxxxxxxxxx
>
> Hello All,
>
> I'm having a difficult time with a rather simple bug (or so I hope).
Using
> VBA, I've created a UserForm. Once Data is entered, it is submitted and
then
> inserted into an Excel Work***. This is done with the usual code, for
> example:
>
> Cells(x, y).Value = Me.TextBox1.Value
> >And to empty it
> Me.TextBox1.Value = Empty
>
> It works fine, except for the following situation. When I open the
> work*** and open the form, the first time I submit information
everything
> works fine. However, after I submit it once, the next time I go to enter
> more information in the UserForm (without closing it and reopening, just
> after it has been cleared from the first entry), I can no longer tab from
> field to field. Instead, it just tabs 5 spaces in the field. Remember,
the
> first time the UserForm is opened it works fine. Any ideas?
>
> Again, if I close the UserForm and open it again, it works fine. But if I
> just submit the information, clear the fields, and go from there, the tab
> doesn't work. Please help me before I go completely insane!!!
>
> Thank you very much!!!
>
> DNAHAWKS
>
.
- References:
- Prev by Date: Re: ActiveWorkbook.Save DOESNT WORK !!
- Next by Date: Re: ActiveWorkbook.Save DOESNT WORK !!
- Previous by thread: TAB properties in a UserForm - Requesting Help from Excel VBA Guru
- Next by thread: RE: TAB properties in a UserForm - Requesting Help from Excel VBA Guru
- Index(es):