Tab order & form population question -workbook included-

Hi,

So as of late I've been trying to get familiar with programming in excel for the workplace and just basically learning the ins and outs in general, currently I am working on my own little projects, one of which I have attatched

The goal of my tool is to create a tool to allow users to take notes in as little keystrokes as possible,

First question how do I control which textbox will the cursor tab to next? As far as I'm aware this is controlled by the order in which the textbox's are added to the form, if there are any other ways please advise.

The second question is, so I have the forms populating in the final textbox, however, if I don't fill a textbox the label still posts to the textbox, can anybody advise on how I could develop it so that if the textbox is not completed then the label will not post to the note?

Thank you to anyone that can help me and if anyone has any questions to ask re the same please do

Controls have a 'TabIndex' property. This defines the order they will be accessed. It is autopopulated when you add controls to the userform, starting at 0 for the first. Each additional control is numbered sequentially.

You can change the TabIndex by clicking on each control in turn and setting the value manually in the Properties Window (Press F4 if not visible).

But that's a royal PITA if you have more than a few controls.

If you click on the first control, then CTRL Click on the remaining control in the order you want, press F4 when you've clicked on them all and enter a 0 in the TabIndex then they will be autonumbered in the order you clicked on them.

To extend that a little, I'm sure you've seen the ALT-(Letter) quick key combinations to quickly select a control - this is done by using a Label and another control.

For example add 2 labels and 3 textboxes to a new userform. Name the first textBox txtAddress and the 2nd txtName. The 3rd textbox is only there to allow focus away from the other 2.

Arrange them neatly. txtName above txtAddress above the 3rd box. Align the 2 labels opposite txtName & txtAddress - set the label captions to 'Name' and 'Address'.

Now click on the label opposite txtName then, while holding down the CTRL key, click txtName, Address label and txtAddress and the 3rd textbox in that order. Press F4 and enter 0 for the TabIndex. Now add 'N' as the Accelerator for the Name label and 'A' for the address label.

Sounds a little convoluted, but it's really simple.

Run the user form. Select the 3rd textbox and press the Alt key. The 2 labels will display an underscore below the 'N' & 'A' characters - pressing Alt-N will go directly to the Name box, Alt-A will go to the Address box.

On a phone so can't view your worksheet so I'll pass on the second query...

You may want to edit your thread title. The Moderators here like to see titles that summarizes your problem, a general title like '2 questions...' is frowned on, generally.

It's a simple check that the textbox is not blank

Please Login or Register  to view this content.

See also comments in the procedures NewNoteButton_Click, which has 2 alternatives for clearing controls, and TextBox12_Change - the Create Note button will only be enabled when there's something to copy in TextBox12. Just a little user interface feature. Why have something enabled when there's nothing for it to do and also provides feedback to the user that the function is not available.