Having a problem with ComboBox on spreadsheet, not Userform. When the Sheet1 is first opened the ComboBox is not populated, if I click on Sheet2 and then Sheet1 ComboBox is populated and works fine. It appears that I need some additional coding.
View 3 Replies
I have a couple shreadsheets I have created, one is for Purchase order's and has 4 different sheets. with one sheet holding addresses linked a drop down menu in the first sheet, all in the same workbook. Also there is a macro within this sheet to print to a specific printer, and a specific number of copies when CTRL p is pressed. The total file size is approx 9 mb. Opening this file takes approx 30 to 45 seconds. There are no links to any outside files, only links within the workbook itself.
The second File I have recently started having problems with (Our Quotation log) is A workbook containing 3 sheets, 2 sheets independant and one sheet linked to the second that Summarizes the first and also has cels to enter information on the person the quotation has come from. I have this sheet formatted as a table so I can sort by name etc when doing followups.
This workbook also takes approx 30 to 45 seconds to open, and on occasion longer. All workbooks are stored on my computer. The PO workbook has had the problem since I created it, although the Quotation log workbook has only had the issue this week.
I have more problem when work with three combobox, will you find me the code to solve this problem.
View 2 Replies View Relatedif a combobox in a userform can be populated by the NAMES of defined ranges in a worksheet?
ie. worksheet contains 3 NAMED arrays: W1 = $C$5:$E$6, W2 = $C$8:$E$9, W3 = $C$11:$E$12. Have the combobox in the userform actully list W1, W2, W3 so that when W2 is picked (for example), cell $C$8 will be selected.
I am trying to find out whether you can restrict the rest of the userform from being available, unless a certain field is entered.
I have a tax invoice userform, I want to restrict the user from entering any other data unless they have selected a customer.
There are other fields such as Customer Address, Customer Number, Disc% and Terms that populate through vlookup code once the customer is selected, so still need that to work once the customer is selected. I just don't want them to be able to enter any other data on the userform without the customer being selected.
I wasn't sure whether I needed to enter code into every other textbox or combo box that if cboCustomer = "" then pop up an error message, but that would require a lot of code to be entered. I have 30 comboboxes and 53 Textboxes that I want to restrict to not being available unless a customer is selected from combobox.
I have been searching for hours trying to find a solution to no avail. What I need to do is make sure that when I press a button on a form, the value in a combo-box should be populated as "text format" not as a number. The reason for this is that when my numbers start with a 0, the leading zero gets dropped and I can't run the rest of my code as the items don't match...
I have tried substituting the "Value" to "text" in : Me.cboItem.value and have tried for hours trying to name dim variables as a String and pass this into the cboItem...with no luck...
VB:
Private Sub CommandButton1_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("Order")
'find first empty row in database
iRow = ws.cells.Find(What:="*", SearchOrder:=xlRows, _
[Code]...
The below populated the combo box cboItem:
VB:
Private Sub OptionButton1_Click()
With Me.cboItem
.Clear
.List = Application.Transpose(Worksheets("Item List").Range("List1"))
End With
End Sub
I have a spreadsheet that on open needs to open a 2nd spreadsheet minimised and delete 2 named sheets in the 2nd spreadsheet.
On close of the first spreadsheet it should then copy 2 sheets with the same name from itself into the 2nd spreadsheet.
This is to start a spreadsheet that will track project risks and issues that I will post further details for as other functions are required.
I want to put a permanent date & time stamp in cell A1 (date) and cell A2 (Time) when cell A3 is populated by any character which would be an inputters initials.
I'm thinking that it will be an "IF" statement but then I am getting confused about how I make it not update when the spreadsheet is opened at a later date and time.
I have two spreadsheets, one gives me the beginning and end of civil twilight as a measure of day vs. night. The spreadsheet has Date/Time in the first column, and the value 45 in the 2nd column when it is night. The second spreadsheet has also 2 columns with date/time and body temperatures of a squirrel. I want to get basic statistics (mean and standard deviation) of the squirrel's nocturnal body temperature, that is for times when it is night (value 45). The tricky part is that Date/Time of both spreadsheets are different. The procedure has to recognize that the date/time of body temperature lies between the beginning and end of the value 45 blocks of the first spreadsheet.
files: twilight sheet squirrel temperature
My goal is to be able to use a combo box on a userform to filter a spreadsheet. I need my users to select the dropdown arrow on the combobox, find the one value they need out of a list of about 50, and have the spreadsheet in the background filter based on that user selection. At this time my form has several checkboxes to filter the spreadsheet which works as expected but again, I think I need to use a combobox for this certain set of data in conjunction with the other checkboxes. Searching on the more obvious terms leads to lots of advice and code on how to filter results within a combobox, but not how to use a combobox to filter a spreadsheet.
View 2 Replies View RelatedI want to filter my results using a combo box on my spreadsheet. I don't mind how this is done, even if it just hides all of the information which isn't relevant. I've done it with a VLookup but I want to be able to edit it easily without the formula popping up. So if you click Barlcays, only barclays appears. I'd also like a button to reset if possible. I've attached an example of how I sort of want it to work.
View 3 Replies View RelatedI have a dropdown box containing text strings. How can I use the selection from a combo box as part of a formula?
So for example I have a spreadsheet that is set up using a search term 'media', I want to select something else from the list e.g 'arts' and I want all of the references to 'media' to turn into 'arts' in the formulas. Kind of like a mass find and replace.
How to open or Print a doc or pdf file from a combobox on a userForm
I have a folder full of doc files. I used a userform on which i put a combobox which contains those files' names and a cmd to open the file.
I managed to copy all the files names to the WorkSheet and listed them in the combobox.
@@@ I need a VBA code to do the following :
1- looking for the file name which matches the one i choose from the combobox
2- if there is a match, show " match" on a lable.
3- when i click the "open" cmd i created on the userform, it opens the file. or even print it and close it
4- prepare for another match.
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.
I am currently using this code to place names in a combobox (active X). How can I use an array to perform each line to all 12 months without repeating the code over and over?Here is what I have:
Code:
Sub auto_Open()
Sheets("FEB").ComboBox1.List = Array("ALL", "ACT", "ROF", "MM")
Sheets("FEB").ComboBox2.List = Array("ACTvsROF_2", "ACTvsPLN_2", "ACTvsLY_2", "ROFvsMM_2", "ROFvsLM_2", [code].....
I have a series of cascading comboboxes on a sheet named report. In the first combo box,cboCategory, the user will have the option of selecting New, Existing, 401k, CPA Information. If the user selects CPA Information I need a user form named CPA to open.
View 4 Replies View RelatedI need to populate combo boxes from a list of data on a separate workbook. I set everything up then found out the way I did it the seperate workbook must be opened before the drop downs are populated with the information. Is there a way to not have the linked workbook open?
Also these workbooks are all contained in their own file that must be duplicated on to other machines and into other larger files. I need that linked information to always follow the workbook contained in the same file. Another words if I have the original file "A" and duplicate it and now have a file "B" I want the combo box in file B to be linked to the workbook in file B.
I'm trying to get some vba to automatically find the range of data in a spreadsheet (So start from a specified point and loop until it's blank) and populate a combobox with this range accordingly. I have read numerous articles and posts but nothing seems to work!!
I am using Excel 2007.
I cannot open an Excel spreadsheet except through the Excel application. This includes through Windows Explorer, on the internet (this forum), in email. I need to save the file first, then open Excel, then open (through Excel) the file.
In Email, I get "System cannnot find the file specified" On this site, I get "Access to the specified device/path is denied" From Explorer, "Cannot find the file.... based on the criteria xls(or one of its components). Make sure the path and file name are correct and that all required libraries are available."
Last time, our IT group couldn't fix it and had to reinstall the entire Office package to get it working again. I'd rather not go through that.
I am just wondering if it is possible to insert a module or a code such that it is user specific.
In detail, there are two types of users: Administrator and User.
If it were administrator, it should ask for a password. If user, it should give the read-only or a protected form of the spreadsheet.
I just need the workbook to pop-up with a msgbox of administrator/user with a radio button or a select button. If administrator, it should ask for a password. Also, disabling the macros should not open the spreadsheet as making this would lead to nothing.
I would like to have a popup appear on the opening of my spreadsheet that warns me of things that are past due or due today. I would like it to be in list form...
For example my source is:
Customer 1 Customer 2
Topic Expected Complete Expected Complete
One 05/18/2007 05/10/2007
Two 05/12/2007 05/15/2007 05/18/2007 05/18/2007
Three 05/12/2007 05/17/2007 05/16/2007
Four 05/21/2007 05/17/2007
What I would like to see is a popup that analyzes this data with the result of:
If run today...5/18...................................
I have an excel sheet that has 3 command buttons on it, i am wanting to open a saved excel sheet that i have on my shared drive from the command button. I know the path of the saved file but how do i get the button to open this file?
As well as this i this i also have another command button what i want to open another sheet in the excel document with the command buttons.
I have a Excel Addin file which i would like to open and view the contents on the spreadsheet
View 1 Replies View RelatedI've got a 'Control Panel' spreadsheet which is all based on UserForms. When a user clicks a particular button, it opens one of many separate 'Regional' sheets which they work in.
When the user closes the 'Regional' sheet, I would like the 'Control Panel' sheets userforms to show again. However I can find no way of doing this as it simply switches back to the 'Control Panel' sheet without loading the forms (as I had to hide the 'Control Panel' useforms to give them access to the 'Regional' sheet).
I'm especially having trouble with loops. I'm a little dense in that department. Here is what I am trying to do. I open 3 spreadsheets. I want to consolidate them into one of the spreadsheets. The first obstacle I face is that one of the spreadsheets has a name which varies. It is always called either "PLR.xls" or "PendingLoans.xls". Also, it will have a number at the end depending on how many excel books have been opened so far in the day, i.e. "PLR (2).xls" or "PLR (5).xls". At this point, all I want to do is be able to select this file consistently. I currently have something like this (excuse my syntax - its saved at work and like I said, I'm still learning VBA).
View 4 Replies View RelatedThere used to be a way to open an Excel spreadsheet and have it go to a specific sheet....... I want to open Grants.xls and have it always go to the "index" sheet....
View 3 Replies View RelatedI inherited a spreadsheet from a recently let go co-worker. This spreadsheet has a lot of important financial data on it, so I really need to get into the spreadsheet. we contacted the former employee and he said he forgot the password. Is there any work around to get into the sheet?
View 2 Replies View RelatedI was working on a multi-tab spreadsheet (7 tabs to be exact) and I went to hide one of the tabs and all of a sudden the worksheet went away and I was left with my empty personal.xls spreadsheet. If I go into tools and visual basic I see my spreadsheet listed as VBAProject (Durex Sales Oct 1 to Oct 28 06.xls) with the 7 sheets listed below it within a folder called Microsoft Excel Objects, but I can't get it back in spreadsheet form.
View 5 Replies View RelatedProblem: I have textbox entries that are part of a Userform that opens using a macro on a speadsheet button. Once this form is open, I can no longer actively work in the spreadsheets.
Need: I need a way to minimize or "put on hold" the Userform so that I can freely move around in the spreadsheet. This could be in the form of a button on the Userform. Then, I need a way to bring back this userform to the point I was at before being put on hold so that I can continue to input entries into the textboxes (again, a buttton that could bring it back). There should be a way to toggle between both worlds.
I have a main worksheet that has two combo boxes. The first combo box has a list of machines. The second combo box brings up a list of models for the type of machine selected. I would like to insert a command button, that when pressed will open a different worksheet with the specs of the model selected in the second combo box. I am having trouble finding a starting point for the code to have the command button perform this.
View 6 Replies View Related
