How To Populate Combobox With List Of Directories On Hard Drive
Aug 17, 2012
Is there an easy way to populate a combobox with a list of directories on the hard drive?
I want to create a way for a user to specify a file without having to type in the full address by hand.
I would like to start in the c:/ root and list the directories in one combobox and the excel files in another combobox. Then if they select say "desktop" it displayes the directories in "c:/desktop" and the excel files contained there in. Then if they click test it does directories in "c:/desktop/test" and so on.
View 2 Replies
ADVERTISEMENT
Feb 16, 2009
Need macro that automate our QC department. What the macro does is it looks up the item number based on the barcode that the scanner reads and brings up the item number, the item description, total of units in a case, how much a single box of the item will weigh and how many units in the inner box may be sold at one time. The trouble is that not all items have an image available so that the person who is doing the checking knows what the item looks like.
There is a Logitech webcam setup to take pictures of the items. The following code allows us to import the image of the item into excel in a given cell:
View 5 Replies
View Related
Jul 3, 2014
code they have in use for saving emails and attachments to hard drive using VBA. I have found the attached- which is close although it only [URL]downloads attachments. I would like to go through the inbox and download files received on a specific date, from the inbox subfolders to sub folders on the harddrive
View 4 Replies
View Related
May 28, 2008
Assume a workbook with some nice pictures.
How do I save all of those to D:TEMP on my Hard Disk ?
View 9 Replies
View Related
Sep 9, 2012
I am working to make an automatic result card in which excel automatically gets data of every student which is present in sheet within the workbook by simply writing roll number of the student in a cell. and i have done it easily by Vlookup and index functions but the only problem i am facing is, that i want to show the picture of each student by roll no. pictures are in one folder on my hard drive, now i want that as the roll number of the student is written the result excel should display the picture (from the folder, each picture named by roll)of the student. for example i write 1234 in roll no cell and want to get and show the picture no 1234 in another cell. (from the folder)
View 2 Replies
View Related
Nov 16, 2006
Populate Adv Filter Criteria from Inputbox with valid data
I've set up a macro to extract 3 different sets of data using Advanced Filter (same data range, different criteria & extract ranges)
There are multiple options (different individual dates) to satisfy the criteria (a date) for each of the 3 extracts and I want the user to select the criteria (a specific date) from the range of unique values in the data range upon which the Advanced Filter criteria is going to be applied. (A bit like the effect provided by Autofilter)
My initial attempt was to capture the criteria date from the user and populate a cell, and then have a vlookup function in another cell check if that crieteria value exists in the specified range. I then ran a loop in the VBA code until the value is valid (ie. exists in the range). However, to streamline this I was hoping to allow the user to see a list of the valid (available) dates when they respond to my Inputbox request for the criteria.
View 9 Replies
View Related
Aug 21, 2014
Excel 2007 and very new to VBA...
I have a userform (named "QAReviewForm") with a combobox (named "cboSupName"). I want it to populate with my named range "SupList".
FYI, the SupList is found on sheet 2, "Administrative Menu" in column E. E1 contains the heading "Supervisors", and my named range formula is
Formula:
[Code ] .....
When it runs, my form opens and the combobox is there, but nothing appears as options for me to select (yes, I have some values in column E).
View 11 Replies
View Related
Sep 19, 2008
I am trying to access and copy some data from the excel file which is located in different folder each time I run the new macro. The file got the same name but only the folder name is different each time.
e.g File is called "testfile", but I have a list of subfolders something like that
date_time (folder name)
15-02-2008_2122 (folder name)
15-03-2008_2189 (folder name)
Each of the above subfolders contain "testfile" with new data and they all are located in the same drive and same mainfolder. Note my Macro file is located in a different drive.
I want when I run the macro all I have to do is to enter Date and macro will automatically pick up the right folder and the right file ("testfile") inside that folder and do all the required task.
View 9 Replies
View Related
Aug 22, 2006
I would like to create a list of folder/directories in the current directory. The only code I've been able to find lists all files in the current directory (not folders).
View 3 Replies
View Related
Mar 20, 2008
I found this nifty program on[url]but there is a problem with it and it's down to the types of files I'm trying to list on my PC.
The excel code below lets you select a starting directory and it will then produce a list of files in a sheet. However when it comes across an internet shortcut file it gets rather confused and won't display the name of the shortcut but what the shortcut stands for. This causes an issue when I try and get some details about the file (eg date, size etc.) as a 'permission denied' error can then occur if it links to a file that is currently in use. For some reason I can't attach an example of a shortcut / internet shortcut so please feel free to make one at your end. eg. I have a shortcut called 'ImageJ' which links to a web address [url]. The code below then reports this address instead of the file name 'ImageJ'. Can any one suggest how to amend this coding to handle this issue?
Option Explicit
'Requires a reference to:
' Microsoft Shell Controls and Automation (shell32.dll)
'Uses techniques found here:
[url]
Public objShell As IShellDispatch4
Public Type BROWSEINFO
hOwner As Long
pidlRoot As Long
pszDisplayName As String
lpszTitle As String
ulFlags As Long
lpfn As Long
lParam As Long
iImage As Long
End Type
View 5 Replies
View Related
Mar 30, 2014
I need to populate two combo boxes from excel sheet, the data will be like below:
Column A Column B
A 1
A 2
A 3
A 4
A 5
B 100
B 101
B 102
So from the above data, one combo box should hold unique values A & B.
On selecting a value from the 1st combo box A or B, respective values should be populated in 2nd combo box.
So the data should be like below:
If A is selected in the 1st combo box, then 2nd combo box should only show the values 1,2,3,4 & 5.
If B is selected in the 1st combo box, then 2nd combo box should only show the values 100,101 & 102.
Friends I need it in a macro and one important point is, this is dynamic and it is not static and the data can be more.
View 1 Replies
View Related
Jun 12, 2006
I have a table, headers "FirstName" and "SurName".
Further a Userform with 2 Comboboxes "FirstName" and "SurName"
I'd like to choose the FirstName (say Jack) in the "FirstName" combobox, and based on that get the choice of the Surnames of all my Jacks in the "SurName" combobox.
Actually my sheet has much more fields and comboboxes, but i think my problem is just that I do not find a way to populate them dynamically.
View 9 Replies
View Related
Aug 9, 2014
provide some code which lists all today changed Excel files on the C drive and hyperlink them.
View 3 Replies
View Related
Oct 22, 2007
I want it to populate a combobox in a userform. Should it go in the code segment for the userform, in a module, or some other place? The following is code I originally found (by Leith Ross of this board) to find the last row in column "A", and load the combo box "ComboBox1"
View 3 Replies
View Related
Jan 26, 2009
able to populate a combobox from data elsewhere in the workbook as follows:
View 7 Replies
View Related
Jul 3, 2009
It's a customer form where I need the contact person (txtContact) to be filled out when selecting the customer (in the cboCustomer).
The data is listed on the sheet "Customer", where all the customer names are in column from B2. The contact names are from C2 in the same sheet.
I have made a list in the namemanager called Contactlist (=OFFSET(Customer!$C$2;0;0;COUNTA(Customer!$C:$C)-1;1)
I have this VBA for getting the customer to the cbobox
View 9 Replies
View Related
Jan 15, 2013
I have created a combobox1 and I have written a code to populate the box the problem is when I run the form and select the data from the dropdown list it gives me an error. I can see the data but just can't select it. I have a command button that I use to save the data I select and insert it into fields on my worksheet. All I just need the drop down box to let me select the data I chose below is my code.
Private Sub ComboBox1_Click()
ComboBox1.Value = .Range("A2:A14")
End Sub
View 2 Replies
View Related
Jun 27, 2014
i would like to create a vba that will populate based on the comboboxes value
like this code
Code:
'for cmb1
'if cmb1 = major 1 then
'if range"F4" is empty then
'copy sheet1 range"A5:R5" to sheet2 range"F4"
'if cmb1 = major 2 then
'if range"F4" is empty then
'copy sheet1 range"A16:R16" to sheet2 range"F4"
[code]....
View 1 Replies
View Related
Dec 29, 2008
i have the following
Dim cn As ADODB.Connection
Dim qc As ADODB.Recordset
Dim Equip_File As String
Dim Equip_ID As String
Dim Equip_Param As String
Set cn = New ADODB.Connection
Set qc = New ADODB.Recordset
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\ServerDISK 1UncertaintiesUncertainties.mdb"
'Populate QC Number Dropdown menu
qc.Open "SELECT [Equipment_QC] FROM [Equipment_Table]", cn, adOpenStatic
With ComboBox12.List
.Clear
Do Until qc.EOF
.AddItem
qc.MoveNext
Loop
End With
Equipment_Title.Text = rst.Fields.Item("Equipment_Title").value
qc.Close
however, i cant seem to populate the list, i get error :424 object required
is this because the first record in the db has the Equipment_QC field blank? i need to be able to have blank fields..
View 9 Replies
View Related
May 17, 2006
I'm looking to change the value of a variable using the selected value of a combobox. I've used the following
Dim DatabaseVal As String
'then on selecting my option from the combo box: "JVU" or "VPU" are the only two options.
DatabaseVal = cmbDbase.Value
When I try and use the variable 'DatabaseVal' to populate a value in another workbook (the workbook contains a reference to the add-in running the above macro), the cell just gets populated with a blank value. I'm sure I'm doing something stupid, but can't see what.
View 3 Replies
View Related
Dec 1, 2006
I am trying to populate a combo box with two columns of data read from two consecutive (or non consecutive) columns of data. The following code is what I have come up with after visiting several of the previous threads on similar topics (couldn't find one that gave a general, concise solution).
Private Sub UserForm_Initialize()
Dim lngRow As Long
Dim lngRowtot As Integer
Parameters1.SG1.Clear 'Clear combobox SG1 in userform named Parameters1
'Find the number of rows required for the array and combo box
lngRow = 12 'Start searching on row 12
Do While Sheets("Timber Properties").Range("H" & lngRow).Value <> "" 'Read until empty col H lngRowtot = lngRow - 11
lngRow = lngRow + 1
Loop
Dim MyArray(1 To lngRowtot, 1 To lngRowtot) As String 'I get an error with the last ingRowtot on this line.....................
View 2 Replies
View Related
Feb 8, 2008
How can i Loop through a combobox's values and compare to a string value and then set the listindex of the combobox to that value?
View 5 Replies
View Related
Nov 7, 2012
I have a VBA form and on form initialize I want to populate a combo box… My array to populate it with could be a massive list so I need to set my array before it populates
I have this code so far but I need my array to be from A5 to the last row in sheet 1
I know how to set an exact range but not one that changes.
VB:
Dim myArray As Variant
myArray =
With Me.ComboBox1
.List = myArray
End With
Here is a sample of the data I need to populate in the combobox.
client_ref
A0008
A024
AA005
AA009
[Code] ....
View 8 Replies
View Related
Feb 22, 2008
I have a userform (uf_PaxInput) with a Combobox (cmb_flight_dest) which I am trying to populate from a worksheet range ("Dest") using the following code:
VB:
Sub LoadForm()
With uf_PaxInput.cmb_flight_dest
For Each Item In Range("Dest")
.AddItem
Next Item
End With
uf_PaxInput.Show
End Sub
The code seems to run okay however whent the form loads the combobox drops down to show only blank items to select. These blank items number them same number of items that are in my named range ("Dest").
View 6 Replies
View Related
Aug 5, 2014
I am looking for a way to have 1 combo box, but be able to click on any cell in a range and yield an individual results. In this particular case I am tracking maintenance, and what my crew's corrective actions were for each location. As this varies day by day I cannot use HLookup or VLookup. Also, the lists vary, and have over 100 options.
What I would like is to be able to click in the cell, and instead of scrolling through a list of 109 options be able to start typing the action and it to auto populate. This gets tedious when there are often 50+ locations with maintenance calls per night.
Furthermore, keeping the results exact for VLookup that is being used on another sheet.
I've attached a blank sheet. Columns B, E, F, & H each would ideally have their own combo box. I could click on any cell in the column and when I begin typing the option it would autofill to the correct list item.
Their respective List are currently to the right under columns J, L, N, & P with their headers matching the exact name they've been given.
View 2 Replies
View Related
Aug 15, 2007
All I want to do is
put a combo box on a spreadsheet,
have it populated, and sorted - ideally, alphabetically with range names already created.
And
I'd like to be able to click on the Range Name and GoTo the location.
View 9 Replies
View Related
Jun 10, 2008
I have successfully used the course booking form as a base for an input form in an accounting workbook that has several pages. (Thanks to Roy and others for the info; the course booking form on [url]is the best explained piece I have found on the net)
What I would like to do is use a range of cells to populate the combobox so that a user can make a choice from the account descriptions (from a sheet named Intro, b63:99) and have the form return the account number (Intro, a63:a99) to the relevant cell elsewhere in the workbook. The user would then have meaningful descriptions rather than numbers to choose from.
My coding for the form thus far is as follows.
View 10 Replies
View Related
Mar 28, 2009
I need to link the textboxes of a form to the appropriate cells associated to the selection made by a combobox. And in the process I need to be able to Edit one of those Textboxes on the fly while the rest will be locked to the user.
Not sure if the editing of the Notes section can be real time of if it must be updated through a button.
View 10 Replies
View Related
Apr 3, 2012
Ive got 12 sheets, one for each month, and I've got a combobox in each sheet, and Ive got a macro for each combobox, that makes it jump to the correct sheet number. The problem is that when I try to populate the comboboxes under the workbook_open() sub, it doesnt work.
Tried
Code:
Private Sub workbook_open()
ComboMaaned.List = Array("Januar", "Februar", "Mars", "April", "Mai", "Juni", "Juli", "August", _
"September", "Oktober", "November", "Desember")
End Sub
tried with
Code:
Sheets("Sheet1").select
and
Code:
Sheets("Sheet1").ComboMaaned.list = Array ...
Seems to crash every time.
View 9 Replies
View Related
Nov 22, 2013
How do we populate a List Box based on two Combo Box Selection on a userform?
Sheet2 has 5 Columns of datas all the way down...
Combobox1 is the Column A
Combobox2 is the Column B
View 3 Replies
View Related
