Re: TAB properties in a UserForm - Requesting Help from Excel VBA Guru

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

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 Worksheet. 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
> worksheet 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
>


.

Relevant Pages

  • TAB properties in a UserForm - Requesting Help from Excel VBA Guru
    ... VBA, I've created a UserForm. ... Me.TextBox1.Value = Empty ... after it has been cleared from the first entry), I can no longer tab from ... first time the UserForm is opened it works fine. ...
    (microsoft.public.excel.programming)
  • Re: image into table
    ... || but if I recall the userform and don't select an image the table is left ... The first time around a one ... cell-table is inserted to hold the picture ... insertone at that bookamrked location ...
    (microsoft.public.word.vba.userforms)
  • Re: IIF Statements
    ... the switch. ... with my Form and subforms and the tab key. ... If it goes correctly the first time, what could cause it to not the second ... Filling out the date field "Date Written Report ...
    (microsoft.public.access.formscoding)
  • userform Field forcing Capital Letters - Thank you
    ... summary sheet and create a tab for this project, ... project was entered in Capital letters ES1001 and in the delete userform I ... Dim ws As Worksheet ... Dim res As Variant ...
    (microsoft.public.excel.misc)
  • Re: editing text
    ... For insertion, one method is probably as easy as ... > I found your information about document variables below very interesting. ... >> Say you have a textbox on a userform with the name of txtFirstName into ... >> the first time the form is loaded as at that point, ...
    (microsoft.public.word.vba.userforms)