Tab stops between form controlls

mrowe · May 16th, 2002, 05:59 AM

Hi,

I've got some text boxes that appear as part of a input control on a worksheet. I can't seem to make it possible to tab between theses text boxes.

Any ideas?
Thanks

Audiojoe · May 16th, 2002, 07:05 AM

Are the textboxes on a form or embedded to your sheet?

mrowe · May 16th, 2002, 07:06 AM

embedded on my sheet....I know about the tab stop on the form but it doesn't seem to have what I needed for an embedded object....

Audiojoe · May 16th, 2002, 07:09 AM

What did you need?

mrowe · May 16th, 2002, 07:12 AM

for the user to input text then tab to the next box. Is it possible?

Audiojoe · May 16th, 2002, 07:16 AM

I know how to do it on a userform, I don't really ever use embedded textboxes etc. Sorry.

Would you consider swapping to a userform?

mrowe · May 16th, 2002, 07:23 AM

sure. I posted a question a few weeks ago on the matter but no one replied.

If I use a user form, how do I get the value the user inputs to land in specific cells with in the workbook?

I'm sure you can help on this one.

Thanks in advance
M

Audiojoe · May 16th, 2002, 07:27 AM

Yeah sure, say you want the value in textbox 1 to go into Sheet1 cell A1, you put this in the textbox's change event (Just double click on it when you're designing it in VB)

Worksheets(Sheet1").Range("a1").Value = Textbox1

Audiojoe

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 05:59 AM	#1
mrowe Board Regular Join Date: Feb 2002 Posts: 232	Hi, I've got some text boxes that appear as part of a input control on a worksheet. I can't seem to make it possible to tab between theses text boxes. Any ideas? Thanks

May 16th, 2002, 07:05 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Are the textboxes on a form or embedded to your sheet?

May 16th, 2002, 07:06 AM	#3
mrowe Board Regular Join Date: Feb 2002 Posts: 232	embedded on my sheet....I know about the tab stop on the form but it doesn't seem to have what I needed for an embedded object....

May 16th, 2002, 07:09 AM	#4
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	What did you need?

May 16th, 2002, 07:12 AM	#5
mrowe Board Regular Join Date: Feb 2002 Posts: 232	for the user to input text then tab to the next box. Is it possible?

May 16th, 2002, 07:16 AM	#6
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	I know how to do it on a userform, I don't really ever use embedded textboxes etc. Sorry. Would you consider swapping to a userform?

May 16th, 2002, 07:23 AM	#7
mrowe Board Regular Join Date: Feb 2002 Posts: 232	sure. I posted a question a few weeks ago on the matter but no one replied. If I use a user form, how do I get the value the user inputs to land in specific cells with in the workbook? I'm sure you can help on this one. Thanks in advance M

May 16th, 2002, 07:27 AM	#8
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Yeah sure, say you want the value in textbox 1 to go into Sheet1 cell A1, you put this in the textbox's change event (Just double click on it when you're designing it in VB) Worksheets(Sheet1").Range("a1").Value = Textbox1 Audiojoe