I'm using 2002. Upon further research, it appears the issue is that I am
not using a "form". My text boxes are laying right on the spreadsheet
itself. If I make a form, the text boxes I place there have a TabIndex and
TabStop, etc. same as VB6. But when placed directly on the spreadsheet,
they do not have these properties.
Using the KeyDown method, the tabbing works - taking me from box to box.
however, as I tab, each box disappears. It reappears once I start typing in
it or double click on it - but it is very annoying!
Any ideas from this point? Can I "embed" a form on a spreadsheet?
"Tim Riley"
wrote in message
news:728647FCFC7A96066D57E39EFB6EA91A@in.WebX.maYIadrTaRb...
>
>
> Paul,
> What version of Excel are you using? We use excel 2000 and our textboxes
> have a tabindex property as well as a tabstop property.
>
> Tim Riley
>
> "pkirill" wrote in message
> news:DC22732AB74973A13875C06766F3192A@in.WebX.maYIadrTaRb...
> > I'm using Excel to create a Drawlist Processor and I have a series of
Text
> > boxes for the user to enter info. I'd like to tab from one to the next.
> > I'm using "KeyDown", but it has issues. I use the TabIndex property in
> VB6
> > for this, but it's not an option when I list the properties of my text
> boxes
> > in Excel's VBA editor.
> >
> > Is there a Reference I need to add or something I'm not doing?
> >
> > Thanks for any help!
> >
> >
>
>
