Set Focus on Specific Control on User Form Using Excel VBA

[@gijshazerswoude9101]

Thank you, this video was exactly what I was looking for.

[@charlesvillaluz1467]

Hi Dinesh, I'm encountering problem with setfocus in a textbox on an before/after update event. It jumps to another to textbox instead on a certain textbox when exit. Do you have some tutorial to go around this problem.

[@md.hadiurrahmanhadiur411]

Really helpful, thanks a lot.

[@grantmorgan7163]

Is there a way to set the focus in a textbox on the next item in the list found inside the same textbox when data is submitted. Basically advance to the next item for the next data entry. Thanks

[@Exceltrainingvideos]

Query is not clear.

[@JosephArouna]

Hello ! I find it very interesting your tutorial on transferring data from the sheet to the text boxes of a form. But I have a difficulty with the transfer of dates whose text box does not recognize the format. How can we resolve this?

[@JK-hm3lf]

Sir after a web page is loaded, I want to set cursor in one of input elements on it so that I can enter data manually. How to do it?

[@Exceltrainingvideos]

These links will help: www.exceltrainingvideos.com/scraping-web-page-data-automatically-with-excel-vba/ kzbin.info/www/bejne/gHrRfXucp8Sca7s Or search www.exceltrainingvideos.com

[@satyenshukla3823]

what option for lost focus in vba excel

[@Gandalfablon]

Thanks for the video. I was trying to understand a Userform but I didn't know what means SetFocus

[@rajhritadutta1168]

Sir, how to auto focus my current date. I have one excel sheet where column is named based on date (say 08-09-2020). There are many columns in this same fashion of each dates from past 5 months. I want to auto focus the current date as and when open the excel sheet. Currently it starts from beginning date not from the current date. How to achieve the same. Need your advise. Thanks.

[@Exceltrainingvideos]

If your headers data as date is in row 1 then loop through the data and select the cell if it is today's date.

[@Exceltrainingvideos]

kzbin.info/www/bejne/apDbf6acjJmFfac

[@Suga_flyhigh]

Hi, Is it possbile to write the tooltip on userform excel vba?

[@باليتركي]

pls, how can appears the cursor inside a specific cell in a specific sheet in excel , wich code can do this? thanks

[@Exceltrainingvideos]

Range("A1").select or Cells(1,1).select

[@باليتركي]

THANKS SIR; PLZ an other question, excuse me for my bad english : What code VB make me able to use only once the textbox to enter data in it , and then not allowed me to enter , that means disable text box or lock it? thank you

[@roelpanis8711]

Hi Dinesh, Good day to you. I really find your tutorial very helpful and educational. That's the reason i subscribed to your channel. I have a problem. I am using a bar code scanner to identify a product. Once the product's bar code is scanned the program will compare its value to a table and display the information about the product. Part of the program's task is that after scanning the product's bar code it must clear the text box where the bar code id is supposed to appear. After issuing the command. Txtbarcodeid.text ="", i issued Txtbarcodeid.setfocus so that it is ready to accept another bar code entry. However, the only thing that is happening is that the text box is cleared but the cursor is not in the textbook. I need to click on it so that the cursor is inside it. The clicking of the textbook intervenes with the continues bar code reading. Everytime a product has been scanned i need to click the text box again. Please help Denish. I need a code that will allow me to make the text box be cleared of information and position the cursor inside it to be ready to accept another bar code reading. Thanks Denish & i hope to hear from you soon. Best Regards.

[@Exceltrainingvideos]

Do you have the bar code scanner's manual?

[@ibnboubakrmohamed3909]

Thank you

[@marcosjcamargo]

Thank's

[@Exceltrainingvideos]

Thanks. Please share with your friends and on social media. You can view more videos in Hindi and English at www.exceltrainingvideos.com/

[@betoroman]

Very Useful, I also susbscribe...

[@uqa1dev1]

thanks sir

[@manny_f]

ControlName.SetFocus You are welcome

[@clairelolification]

love ya

[@Exceltrainingvideos]

Wow!