Name: Excel 2010 VBA Tutorial 56 - ActiveX Controls - Drop Down Box
Uploaded: 2013-08-05T14:46:42+00:00
Duration: 3 min 49 s

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
Published: 8/5/2013
View Count: 19,569

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 . ...