Excel VBA ActiveX Controls #1 Worksheet Button and Textbox

Рет қаралды 214,891

Күн бұрын

📊 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)
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:
🔒 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/

Пікірлер: 57

@candybose 7 жыл бұрын

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!

@MYJETGLO 11 жыл бұрын

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

@kathiac3299 8 жыл бұрын

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.

@krn14242 11 жыл бұрын

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

@ExcelVbaIsFun 11 жыл бұрын

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

@aliedres7257 6 жыл бұрын

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 11 жыл бұрын

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

@1988Ssk 6 жыл бұрын

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.

@bluezero2xxx 9 жыл бұрын

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

@paranguaricutirrimir 11 жыл бұрын

Great video! Thanks for sharing your knowledge.

@eyesofthetiger1967 8 жыл бұрын

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.

@ExcelVbaIsFun 11 жыл бұрын

very cool kd1s! Thanks for that! Dan

@BobWila 10 жыл бұрын

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.

@jaferct4218 7 жыл бұрын

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 this?????????

@PeteBaldwin 11 жыл бұрын

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.

@ExcelVbaIsFun 11 жыл бұрын

Glad it helps! Dan

@pointec9009 7 жыл бұрын

THANK YOU my problem was the Design Mode enabled

@romanvasiura6705 8 жыл бұрын

Hello Guys! I have one question. How we can scripting code VBA for this example.... When I see Bil... (Billy)... How I can choose it as like Esc or clik for mouse... but I want do it (for keyboard buttons) - Enter and Tab - I want add this buttons. It's real adding for our code VBA - how I can do it?

@ExcelVbaIsFun 10 жыл бұрын

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!

@DigiWongaDude 11 жыл бұрын

Hi, thanks for this. I really need to know why something. You type me. and get access to your controls in the dropdown list. Sometimes I get this sometimes I don't. I'd really like to know how to display them consistently in that dropdown list? if I type: ThisWorkbook.Sheets("MySheet"). with a dot, I get nothing! if I type: set sh = worksheets("MySheet") and then type sh. [I get some items, but NOT my controls], please can you help me? I will be so grateful.

@jurikashan5955 2 жыл бұрын

hu Hiw can i add, "Biscotti" + "dan" + "Billy" all in one text box. means combine two selection to the same text box with comma to separate "," ?

@nareshobula9914 10 жыл бұрын

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

@user-sj6qi2yu3o 4 ай бұрын

I am CONFUSE? what is the application of this tutorial? how does it applies to our work?

@Deeedot1 11 жыл бұрын

thanks very useful video!

@ExcelVbaIsFun 11 жыл бұрын

Thanks again, MYJETGLO! Dan

@mah22jadhav 4 жыл бұрын

when submit button press on basis open hyperlink cell in excel? need vba code

@johnwatkins39 6 жыл бұрын

Couldn't you do the same thing for an image?

@beenay18 Жыл бұрын

running sub-procedure from button malfunctions but running it from vba editor works fine? this problem started when i protected all worksheet. I wrote the following code to unprotect all the sheets at the beginning of sub-procedure and again protect all worksheet in the end of sub-procedure. Please help! sub name() Dim ws As Worksheet For Each ws In Worksheets ws.Unprotect code Dim ws As Worksheet For Each ws In Worksheets ws.Unprotect end sub

@DigiWongaDude 11 жыл бұрын

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 :-)

@wojciech765 9 жыл бұрын

Hallo How can I hold a Label in range ("B1:C3) with code VBA. Is the way to do it?

@ExcelVbaIsFun 10 жыл бұрын

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

@itzjovikthecrazy1488 9 жыл бұрын

Why You always make excel videos? I need powerpoint also but hery I will go to school at monday to friday and My buisnes is sometimes saturday and sunday

@DigiWongaDude 11 жыл бұрын

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'

@ExcelVbaIsFun 11 жыл бұрын

In this video, we used some examples, such as Pressing promted code, the code took the selected cell's value and shoved it in a text box. Then we combined custom text aka "biscotti" with the selection and put it in the textbox. I'm open to suggestions, but there are billions of practical applications/examples, and I'm not quite sure which ones people are looking to find. Plz help me if you have ideas. Gracias! Thx for watching. Dan

@gregsdoodles4547 2 жыл бұрын

How do Sally and Jess feel about being listed under Dudes?

@ExcelVbaIsFun 2 жыл бұрын

We're all dudes! kzfaq.info/get/bejne/fNd9gqeoyrScnIU.html

@koohlog 11 жыл бұрын

i don't have a developer button on my excel. =( x

@germanjunio7663 10 жыл бұрын

Hi Dan! Can you help me how to add tabs in multipage tab? thanks!

@ExcelVbaIsFun 9 жыл бұрын

just uploaded for you, kzfaq.info/get/bejne/ib1lldCJ0tmdpac.html

@ExcelVbaIsFun 9 жыл бұрын

ExcelVbaIsFun Multipage Add Tabs, Move or Delete Tabs, Change Tab Selection in Excel VBA - SpeedTip

@S7r1k3r581 10 жыл бұрын

why is it: me in me.tbperson1.....?

@md.saifulislamtuku9303 5 жыл бұрын

thanks from bangladesh

@ermurali01 11 жыл бұрын

Hi Your Videos on are gr8, it would be nice if you can give practical use with examples Murali

@ExcelVbaIsFun 11 жыл бұрын

Check out my basics series video 1 or two, i show in depth how to get this. Thanks!

@whall071 9 жыл бұрын

I know this is a pretty late comment, but how do you add ActiveX controls to Microsoft Office when you're using a Mac?

@ExcelVbaIsFun 9 жыл бұрын

Whitney Hall I'm not sure how this works on mac, sorry Whitney!!

@whall071 9 жыл бұрын

No problem! I figured out a way around it. I was making it way more complicated than it needed to be.

@DaeViZ0n3 9 жыл бұрын

Whitney Hall pls tell me more about how you solved your problem Oô I mean... I know recording and scripting macros was possible on office for mac. but does it really work properly? with the exact same codes thay you might just copy from a windows-machine? regards

@faizalbahrom8580 2 жыл бұрын

When i use me.### error occur. Please advice

@ExcelVbaIsFun 2 жыл бұрын

Hi Faizal, can we see what code you're using and what code module you have it in?

@LiquidSnake1988 6 жыл бұрын

I really want to copy this watch?v=wqtcX6IRnfs this guy a speaking robot doesnt gives a link or tutorial... I badly need it.

@Marcel-ix9tb 8 жыл бұрын

@azhadshamim3122 2 жыл бұрын

I think you confused Hhhhhhh

@112r 7 жыл бұрын

why there can't be a simple video where no complicated names are selected for every freaking button and cell. horribly annoying video. all time is spent in renaming the cells

@dancor31 7 жыл бұрын

you get what you pay for