:-)
Cool -thanks Harold
I think I might create a single procedure for this for universal tab use,
with arguments to specify if a form element is 1st or last in a collection,
and if so, just to not "tab" anywhere, otherwise tab forward or backward...
Or I wonder, maybe the numeric number of form elements within a form could
be used instead...

As for my development, do you therefore think, to achieve something both
form and tabled data as I mentioned, that Excel worksheets with embedded
ActiveX elements is the best (and only?) option?
Or can a userform be embedded in a worksheet?

Cheers
Thanks
Matt


"Harald Staff" wrote in message
...
Hi Matt

This makes perfect sense. Too many IT departments take pride in preventing
efficient use of computers. Ok, for tabbing, it's about trapping the press
of the Tab key, which has keycode 9 and to see if there's a Shift pressed
simoultaneously, if so go back instead of forward.
With Textbox1, Textbox2 and Commandbutton 1, in that tab order, code goes
like this:

Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal
Shift As Integer)
If KeyCode = 9 Then
If Shift 0 Then
CommandButton1.Activate
Else
TextBox2.Activate
End If
End If
End Sub

Private Sub TextBox2_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal
Shift As Integer)
If KeyCode = 9 Then
If Shift 0 Then
TextBox1.Activate
Else
CommandButton1.Activate
End If
End If
End Sub

Private Sub CommandButton1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger,
ByVal Shift As Integer)
If KeyCode = 9 Then
If Shift 0 Then
TextBox2.Activate
Else
TextBox1.Activate
End If
End If
End Sub

It's a dirty job, but someone has to do it :-)

HTH. Best wishes Harald

"Matt Jensen" skrev i melding
...
:-)
Yes I'd noted that problem about the Tab button... What is the relevant
code
to replicate it?

It's hard to explain what I'm doing but it will be worthwhile doing it
in
Excel I believe, although I don't have many other choices really
(would've
rathered do it in a database to HTML via ASP or something but time and
cost
constraints prevented it thanks to our austere IT department).
Essentially, I need to provide an interface for manipulation of tabular
data, and need it to look as sleek as possible, and can't have it in any
executable or database... :( Nevertheless, Excel will provide for a
suitable short term solution which is the aim..

So..
Your point though, is partly why I asked the question, because I was
wondering if I should or if it is possible to place the form elements
inside
a form that would need to be 'inline' in my worksheet, instead of
'embedding' the elements in my worksheet. All of the examples of the
uses
of
forms that I've seen have used them as dialogue boxes that effectively
'popup', which is not what I want. What is want is part form, part table
data.

Thoughts?

Cheers
Matt

"Harald Staff" wrote in message
...
Hi Matt

Users won't be able to jump between the controls with the Tab button
(unless
you wite specific code for it in each and every control) and
optionbutton
won't group. Not wrong, just inconvenient at times. Let me reverse the
question; what do you need a turbo calculation engine and 16 million +
cells
for in this form ?

HTH. Best wishes Harald

"Matt Jensen" skrev i melding
...
Howdy
Is there anything wrong with creating an application by placing form
elements such as a text boxes directly onto a worksheet?
Cheers
Matt