Excel 2010 VBA Tutorial 56 - ActiveX Controls

Excel 2010 VBA Tutorial 56 - ActiveX Controls - Drop Down Box

How to use Active X Controls to add drop down boxes to your spreadsheets.
Website and Forum: http://yourprogrammingnetwork.co.uk - Please direct any questions you have here.

Closed Caption:

hello everybody and welcome to my 56
vpat 2010 tutorial in this tutorial is
going to show you how to create a
drop-down box in with your iDevice
controls so a very similar to the text
box we just delete of textbooks and then
insert and in fact that's just controls
at that there's other in an extra one so
we'll have our name then we'll have a
combo box as well so combobox is this
one here and if we can select it and
highlight across like this and then you
notice that it's got dropped on the end
so in order to fill a drop-down that's
just put in some entries here so that's
just have much may I don't know one
right to do this click and drag them
down and then this is going to be our
this is cool this month's that in here
you go to properties and then we go to
this box full range then we just need to
put in sheet wad and then we can /
references using h1 for you to h 12 or
pictures i've just given them a name i
can just use the mumps and obviously not
because it isn't like it h 12
and why doesn't like that just hasn't
named them all right then again never
two months and then back into here this
full range so she warned months and then
we
design mode click on this drop-down you
notice that they're all SAT there and we
can select them and all flower box here
and then similarly to the text box if we
give this a name so hey drop and then if
we go into our cage and we can take that
value out of it so if we the month
string and let's call it using 12 so big
pieces of any keywords and then he's
among equals this work for sheets she
won . dropped our month value reference
in exactly the same way and then we can
just use it in here so now what
we click this buttered take her out as I
mode submit my signs your request for
month march will not be processed so
that is how you use the drop-down list I
asking to be it for this tutorial in the
next tutorial I'm going to show you how
easy a spin button so thanks first thing
and hope to catch cc'd

Video Length: 03:49
Uploaded By: YourProgrammingNetwork
View Count: 15,451

Related Software Products

Visual Basic Activex Controls

Published By:
helpsofts

Description:
Professional VB Activex Controls for visual basic 6.0 HVEE 2008 (VB ActiveX Controls) provides professional VB ActiveX Controls for Visual Basic (VB) that are easy to use and customize to give you the ability to quickly and easily create professional vb applications that have the latest visual styles and advanced features that are seen in such products as Microsoft Windows, XP, vista regardless of their operating system. Smart Professional User Interface (GUI) for VB or any activeX platforms ...

Related Videos

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. **Limited Offer** Learn to Make Excel Do Your Work For You with The Ultimate Excel Programmer Course – Get the ...
Video Length: 07:04
Uploaded By: ExcelVbaIsFun
View Count: 79,699

How to create and use User Controls in VB.NET

Check out the website: http://www.mkasoft.com for more tutorials and how to. hr / bClosed Caption:/b ok hello guys in this video we are going to see how you can create your own user control and how you can put that inside the DML and ported to other applications so before we start the control that we're going to create is going to display a message letter by letter ok it will be like a label but you know what few other ...
Video Length: 19:21
Uploaded By: mkaatr
View Count: 37,687

Excel 2010 VBA Tutorial 54 - ActiveX Controls - Command Button

How to use Active X Controls to add buttons to your worksheets that run macros. Website and Forum: http://yourprogrammingnetwork.co.uk - Please direct any questions you have here. hr / bClosed Caption:/b how everybody are working to my 54 BB 85,000 tutorial and this tutorial is going to show you how to use the activex controls in your workbooks and activex control is essentially the same as user forum accepts its going to integratebr ...
Video Length: 04:41
Uploaded By: YourProgrammingNetwork
View Count: 35,043

Adding VB ActiveX Controls - Checklist Survey in Microsoft Word 2010 (part 5 of 9)

This video shows how to Add all the ActiveX Controls Checkboxes CommandButton and Labels for Microsoft Word 2010. Word Document is built using Visual Basic Editor and is saved as a Macro Enabled Document (.docm). VBA ActiveX Controls Used: Checkbox, Label, Commandbutton. Survey has checkbox options for a customer satisfaction survey checklist. Commandbutton allows user to clear the survey and all data is auto-calculated. (part 1 of 9) hr / bClosed Caption:/b hello everyone ...
Video Length: 09:40
Uploaded By: Alex Cantu
View Count: 24,302

Excel 2010 VBA Tutorial 55 - ActiveX Controls - Text Box

How to use Active X Controls to add user input text boxes to your spreadsheets. Website and Forum: http://yourprogrammingnetwork.co.uk - Please direct any questions you have here. hr / bClosed Caption:/b I don't worry i walked into my 55th vba 2010 tutorial and this tutorial is going to show you how to use text boxes on your worksheets so again we need to go into design mode and I'm just going to drag the submit button down here ...
Video Length: 03:38
Uploaded By: YourProgrammingNetwork
View Count: 17,412

Form Filler ActiveX control (using Visual Basic 6.0)

Demo of my ActiveX control "FormFiller", in a Visual Basic program which directly exposes the properties and methods of the control to the user. This is used for arranging and printing official forms. The text boxes at the top are for sending data to the control, as would be in a row of a database table. You will see me sending various bits of data to the control and then having it auto fill the form based on the data. The control includes a print function which takes font name and size as ...
Video Length: 06:00
Uploaded By: DFPercush
View Count: 16,706

how to create ActiveX control in vb 6

in this video i will show you how to use activex control in vb6 hr / bClosed Caption:/b hello friends in this tutorial i will show you how to use activex control access control is used to make good components that are used in toolbox so i will show you a simple addition component which will take two inputs and produce edition of the values i will change the caption here to some and to display yeah yeahbr ...
Video Length: 04:37
Uploaded By: tps
View Count: 15,571

VB Macro Code for Checkbox - Functional Checklist Survey in Microsoft Word 2010 (part 7 of 9)

Entering the Visual Basic Macro Code for Next Checkboxes.This video shows the final end product of a Checklist Survey built in Microsoft Word 2010. Word Document is built using Visual Basic Editor and is saved as a Macro Enabled Document (.docm). VBA ActiveX Controls Used: Checkbox, Label, Commandbutton. Survey has checkbox options for a customer satisfaction survey checklist. Commandbutton allows user to clear the survey and all data is auto-calculated. hr / bClosed Caption:/b br ...
Video Length: 03:58
Uploaded By: Alex Cantu
View Count: 14,203

Excel 2010 VBA Tutorial 57 - ActiveX Controls - Spin Buttons

How to use Active X Controls to add Spin Buttons to your spreadsheets. Website and Forum: http://yourprogrammingnetwork.co.uk - Please direct any questions you have here. hr / bClosed Caption:/b font color="#E5E5E5"I don't everybody/fontfont color="#CCCCCC" and welcome/fontfont color="#E5E5E5" to my 57/font font color="#E5E5E5"BB/fontfont color="#CCCCCC" 8520 tutorial in/fontfont color="#E5E5E5" this tutorial is/font going to show ...
Video Length: 05:44
Uploaded By: YourProgrammingNetwork
View Count: 13,394