Texboxes ActiveX

[pulsar777]

Hello!

I'd like to have 3 textboxes and be able move from one to another by hitting TAB key. I tried to group them in a Frame which allowed me to use the TAB key, however I'm not able to store their values or refer to them in a code.

Any suggestions?

[gmr4evr1]

Change the TabIndex #, in the Properties window to the order you want the tab button to follow.

[pulsar777]

Thanks, I found TabIndex only in Userform Textbox properties. I look for embedded Textboxes, so I went to: Insert\ ActiveX Controls\ More Controls\ MS Forms 2.0 Frame. Then Right Click on Frame \ Frame Object \ Edit, and inserted new texboxes from ToolBox menu.

[gmr4evr1]

You're welcome. Sorry, I gave you instructions for TextBox not realizing you were using ActiveX. FYI, ActiveX not a good idea, reeks havoc, a lot, avoid at all costs if possible.

[fredlo2010]

Hi,

I would recommend staying away from activeX as well. Try this code and see if it works.

Please Login or Register  to view this content.

Hope this helps

[Leith Ross]

Hello Hello gmr4evr1,

Welcome to the Forum!

If you post a copy of your workbook, I wcan help you with the code.

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

[gmr4evr1]

I don't think the above post was meant for me.

[pulsar777]

Hi and thanks all for your tips!
I just found out how to refer to embedded Textbox object value,
and must admit how simple it is. I only got confused with no Intellisense list and missing Textbox code field (only Frame available)
but now I realize why. That textbox is actually a part of Frame. I also attach here a simple example.