Microsoft Excel Forum

i have a problem with my code i want to connect excel userform to access and that done my problem : i want to make a search in a table in ms access db between 2 dates and records belongs to 2 criteria (me.combobox1) and (me.combobox2) so i make a connection and it export only records between 2 date and not use my criteria .please help

I have a spreadsheet of 75,000 rows that is sorted and grouped by AcctNum. There are several records for each AcctNum. The user wants to be able to collapse records so that only the first record for that AcctNum displays and the other records for that AcctNum are hidden. Then when the user clicks anywhere in that first AcctNum record, all of the...

Hi there, Is there anyway of setting the time series to show just the data relating to a new date. If customer x, living at zipcode/postcode3 has been waiting for 10 days as at 2nd Feb 18, 11 days as at 3rd Feb 18 and so on, when their order is finally delivered, their data set remains on the map. I am looking for a map that will show the...

Hi there, I often have problems finding things on the desktop. So I do the Sort By -> Name which organizes them by name.But the next time I login it seems to go back to a random order, and I can't figure out why or how to keep it from doing this. Has anyone else had this problem? Please help. I did not find the right solution from the...

OK, So I have a very specific problem that I hope to make not-a-problem, but I need some help. I am a complete neophyte when it comes to making Macros. I’ve got a customer that has put long lists of references in a single column in Excel (normally, the references are just in one cell). I’ve figured out how to consolidate a selected portion of a...

When I bought it, it was in French or Spanish. How do I change language?

Introduction : Excel worksheets all have names, but although the default name for a sheet will always match the module name for that sheet, it is easy to change the name of the sheet, yet not so easy to access and change the module name. If this is a problem you've struggled to deal with, then read on. Worksheet Name : This is...

Hello, I have combobox list with product options: Z1 Z2 Z3 etc. and I want to to repeat the same macro (copy and paste range) every time when sb choose product from the list. Attached you will find a .xls with the recorded macro I don't know how to relate the functioning of the macro from the choosing of the value from Combobox

Dear Reader My excel workbook consists of the following:- Sheet1: Data for pivot table Sheet2: Pivot Table Sheet3: Options to be checked in the "Values" of the PivotTable Field List. Is there a macro for automatically checking options in the pivottable field list from the values in Sheet3?

I am looking at an Excel sheet that has this formula in one cell: =1+'weighted avg mu'!F22 I know that the mu stands for Mark Up but I don't understand '! and I don't understand why you would add 1 to a Mark Up. I'm really confused.

Am in a bit of a strait. Looking for a non-VBA excel formula to work with rental rates in our workbook. I am hoping there is a simpler Excel method to use other than nested IF statements. The rental rates for equipment is billed by the day, week and month and breaks out as follows: 1 - 2 days is by the day. 3 - 10 consecutive days is by the...

I have some code that I'm trying to run in Excel 2013 VBA. Periodically when I try to run my code, I get a message saying "Code execution has been interrupted". If I click debug and then F8 the rest of the way through it, everything runs fine. I can also click Continue and it works. It almost never stops at the same place. I've never had this...

G'day, thanks for reading. ok here is my problem. I have a timetable in excel which I am counting the hours for cells in the right hand side under categories. I am attempting to combine different types into single counts. I have been having trouble and have thought about using the following statement however it is not working ...

One of the main reasons that Excel development is so easy to get into is that the Macro Recorder (Tools / Macros / Record New Macro...) can produce some (albeit pretty basic) code for you to look at and build upon. Don't know the right object? Not sure of the right procedure? Excel can give you the tips you need to get into what you're...

I created huge document in MS Excel 2010 I added in it many sheets, also formulas, formatting and etc. Today I've worked with it, and Excel popped up that application isn't responding I had to close it. When I opened it again, some of my sheets missed from the file. I launched built-in microsoft tool for repair xlsx file, but it could get back...

I have created a button on Excel which I would like, when clicked, to attach the completed workbook to an email and be sent directly to a mail recipient. How do I do this? The button has been created and is clickable I just need the process of embedding the/a code to it and what that code is! Many thanks

I have used following code and run successfully. Sub mcopy() a = Worksheets("CRM").Cells(Rows.Count, 1).End(xlUp).Row Dim myModule As String myModule = Application.InputBox("Enter a Module") For i = 2 To a

We have a school project which is to create a VBA through Excel and I have problem about coding attempts in Log in. Everytime I open the file and put some incorrect username and password once the message box appears and say that "You have entered an invalid username/password 3 times already" what would I do to make it 3 attempts? Thanks for the...

Hi all, I have a spreadsheet which has two data sources on. Table 1 has data relating to patients who have been discharged from the wards at the hospital I work at and Table 2 has the list of all the wards at the hospital. I can make a pivot table from table 1 easily however it will only list the wards present in table 1. Some of the wards may...

I am a new one with VBA for excel. When I write down khmer unicode character in active textbox in excel, it always displays ?. How can to display it correctly? Thanks

I have a user who was working on an Excel 2007 file from a thumbdrive.. all of a suddem the file will not open and generates the following error: "Excel cannot open the file 'filename.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the...

I am trying to create a macro that copies the active worksheet to a new worksheet and paste values only. For instance, Sheet1 is the active sheet. I want to make Sheet1(2) with values only. Additionally, I evaluate each row of the Sheet1(2) to look for a value of X in a cell in each row. If there is an X, then the row is deleted. My...

Good Day, I created a macro in Excel that works great. It formats multiple sheets exactly as expected, but when it completes it seems like I have to close out four or five worksheets before I can close out of excel completely. One item of note: I experienced errors when I first built the macro. When I went in to edit the macro, I noticed a...

VlookUp or Vertical LookUp is a function that enables Excel to ‘Find’ related items from within a range stored elsewhere. Elsewhere can mean another excel workbook on another PC, but can also mean a range in the current worksheet. In any Range reference in Excel, a ’$’ preceeding an element of the address, simply tells Excel not to be clever...

Greetings, I am trying to find out if something is possible in Excel VBA. I would like to use a string or integer to modify/represent the name of a range object. Please note that I do not have a range stored in string format. For example, I have the following range objects already set: rng1, rng2, rng3, etc. I am looping through rows and...