Prevent Arrow Keys From Moving To Other Textbox in Excel VBA

Рет қаралды 6,801

6 жыл бұрын

📊 Free Workbooks: www.excelvbaisfun.com/links?u...
🥷Join Excel Ninja Pro: www.excelvbaisfun.com/ninjapr... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more)
This week, we had a question about the Arrow keys taking the focus away from a Textbox and how to stop this from happening. Quick Tip!
Download Link: excelvbaisfun.com/mdocs-posts/...
Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: www.excelvbaisfun.com/secure-... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: www.excelvbaisfun.com/custom-...
👋 Business Inquiries, Consulting, Comments, etc: www.excelvbaisfun.com/contact/

Пікірлер: 19

@excelisfun 6 жыл бұрын

Thanks for the Fun, ExcelVbaIsFun!!!!

@ExcelVbaIsFun 6 жыл бұрын

Thank YOU, my good sir!

@MySpreadsheetLab 6 жыл бұрын

Thanks for the Keycode tip Dan! I didn't know this. And cool intro!

@ExcelVbaIsFun 6 жыл бұрын

Thanks Kevin!!

@semperdiscendum7439 6 жыл бұрын

That was awesome! Thank you!! Please keep enlightening us!! 👍👍

@ExcelVbaIsFun 6 жыл бұрын

Thanks, Shashikant! Will do!

@kellyspoolhall761 Жыл бұрын

Thank you for this!

@krn14242 6 жыл бұрын

Love the new intro. Great tips also.

@ExcelVbaIsFun 6 жыл бұрын

Thanks, Kev! I appreciate you!

@sciencepolitique6443 6 жыл бұрын

Do you have a video that show how to Disable ComboBox change event ?

@shakhobiddinnakiev6767 5 ай бұрын

thank you bro!!!

@berban 5 жыл бұрын

Cool! I didn't know you could cancel the keypress that way. By the way, the keycodes are incldued as VBA system variables. Down is vbKeyDown and up is vbKeyUp :)

@kingimad6243 4 жыл бұрын

Hi sir, Please can you tell me how to disable windows (start) button when userform is open

@arielzabatecuizon5147 3 жыл бұрын

now the opposite, how to use arrow to select the next below textbox or up textbox or rightside or leftside textbox using arrow?

@kedarhatkar 6 жыл бұрын

Is it possible to select a cell manually on an Excel sheet while a form is open, please make a quick tip video if possible, thanks in advance

@FRANKWHITE1996 6 жыл бұрын

thanks

@Tat-cx1lr 6 жыл бұрын

Bonjour. Tout d’abord merci pour vos vidéos qui rendent service à des milliers de gens. Je voudrais extraire les codes produit et les numéros de page d’un catalogue en PDF vers Excel. Pourriez-vous m’aider. Amicalement.