Excel VBA ActiveX Controls #1 Worksheet Button and Textbox

Using a Button and a Textbox directly on a worksheet to invoke some simple VBA code. In this lesson, we show the user how to access the Design mode in the Developer ribbon.
Design mode allow you to resize/reshape ActiveX items and right-click,Properties to edit properties.
We also give the button and textbox a custom name and watch how excel utilizes that name.

Fantastic Developer Tools:

[MYJETGLO]

Brilliant D!!! Love how you explain in a way that enables us to easily understand. Good Stuff mate!!

[ExcelVbaIsFun]

Thanks for stopping by to thank me and for watching!! Dan

[krn]

Neat, looking forward to viewing the others. Thanks Dan.

[ExcelVbaIsFun]

Wow, good work, Digi! Thanks for that helpful tip. Dan

[paranguaricutirrimir]

Great video! Thanks for sharing your knowledge.

[candybose]

Hi, This is exactly what I was looking for. however how do we combine multiple texts and get the output in the text box. please help. Thanks a ton for the video!

[nareshobula]

cool video Dan.. you have awesome voice like your guru mike:):)

[ExcelVbaIsFun]

using "Me" is pretty cool. When you're writing code in the worksheet you're using (rather than a module or in a userform), "Me" means that current worksheet and when you type me and put a period, it automatically shows all the options available to you in a dropdown form. Also allows you to not have to refer to the worksheet as thisworkbook.sheets("sheet1"), but rather, you can just put ME.

I have a video called "Why ME?" talking about utilizing this. PEace!

[kathiac]

im trying to create a command button that counts the elaspsed time in seconds since the button was pressed. what type of code do you think i should write? im new to vba and am having a hard time with it, especially this task.

[aliedres]

Hi Guru Dan,
First, I'm thanking you for your amazing videos, and I need your help using ActiveX command button to browse, insert and resize multi photos (with keeping their aspect ratio) in excel determined range for each photo, for example:
Photo01 = Range(A1:E10) until Photo20..., as landscape photos, with rotate the portrait photos to be landscape.
Thanks...,

[ExcelVbaIsFun]

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

[pointec]

THANK YOU my problem was the Design Mode enabled

[DigiWongaDude]

Just thought I'd point out too, that the keyword 'me' is relative. It can be a workbook, a worksheet, a form or pretty much anything...it's relative to where and how it's being called. It's not specifically the same as, say, 'ThisWorkbook'

[bluezeroxxx]

If i want a number on the numpad to run a macro, how do i do that? Does it use activex controls?

[Ssk]

I have a Master Excel Workbook in which i have linked the relative documents using hyperlinks. These workbooks open when i click on the Hyperlink. i have also created a back Link to Direct back to the Master. But in the process when i get directed back to Master Excel Workbook the Other Workbook which opened by clicking hyperlink remains open. I want those opened workbooks to close when i click back to master file. Is there a way in which i go directly to the master Excel Workbook by simultaneously closing the other Workbook.

[eyesofthetiger]

Hello ExcelVbalsFun. I would like to learn a macro for importing results to an excel sheet from a structural engineering software automatically as soon as the analysis is terminated and without being present atthe computer.

[DigiWongaDude]

I cracked it. To access a control so it displays in the list, you need to target the specific sheet in the Dim statement. Not "...as sheets" not "...as worksheets" and not "...as sheet", but the actual sheet. So "...as Sheet1" would work (if it has a control).

dim mySh as Sheet1
mySh. ([with a dot]... then brings up a list with all the controls on that sheet in the menu

Thought it only fair to share :-)

[jaferct]

hi sir,
i have a problem with active x controls, when i add a text box and write anything in the box its word going to compress,
how to clear

[BobWila]

great tutorial, can you make tutorial like this that uses array? like i have names in a cell that is separted by a comma. if i type name that i want to find in each cell, it will automatically copy the name/s in each coresponding cell beside each cell. 

[PeteBaldwin]

How would I go about making it work the other way round - essentially as a search box. If I type Dan and hit the button, I need it to highlight dan in the list. I know this is basically the same as ctrl+f but its been requested at work.... Cheers.