I need a macro that will create a popup message any time 1) a new worksheet is created and 2) a worksheet is copied. The contents of the message left aside (use "message" as our example message)
View 9 Replies
I need to add to a current macro which currently copies the master tab and creates a new tab with tomorrow's date on it. For reference here is the current macro:
View 3 Replies View Relatedi need to create an user form that creates an ordered list when an input for the starting number, the ending number, and the increment is entered by the user. the ordered list must also start in the specified cell that is entered by the user. i understand how to design the user form but the coding necessary for making the macro baffles me.
View 4 Replies View RelatedI am having an issue with Excel creating a duplicate file when logged in as a user with restricted permissions on our network. If I modify a file while logged in as another user, excel will save the file but will also create a duplicate file with an eight character random name and no file extension. For example if user "Dave" opens a file called test.xls and saves it, in that same folder on the server a file named 296E9E20 will be created. Users are using Windows XP SP3 boxes and the server is running Win 2003. I am not sure why this only happens with Excel.
View 3 Replies View RelatedI have a macro that selects and copies and pastes a range of data from one sheet to another sheet. It works perfectly except it is pasting all the cell formatting and formulas and i only want or need the values.
View 8 Replies View RelatedI have a sheet which is a basically my template, it has a bunch of formulas etc on it
I need to create about 200 copies of this exact sheet and its formatting etc, is there anyway you can bulk copy a worksheet or does this need to be done individually?
I have created a macro, which copies data from 1 sheet to another, in order to Format and rearrange the columns.
The problem I have is that if I "Insert" a column on sheet 2, I have to amend all of the ranges in the macro to reflect this.
Sample of the code
Worksheets("FTIS Data").Select
Range("e5:e" & Range("e" & Rows.Count).End(xlUp).Row).Copy
Worksheets("Quote Tracker").Select
Range("c5").Select
ActiveSheet.Paste
Worksheets("FTIS Data").Select
Range("g5:g" & Range("g" & Rows.Count).End(xlUp).Row).Copy
Worksheets("Quote Tracker").Select
Range("d5").Select
ActiveSheet.Paste
I have a data sheet like so:
A B
Name Grade
Jim 82%
Bob 90%
Kelly 71%
June 95%
And I also have two cells which are designated as the low and high range. (ie C1 = 85% and C2 = 100%). I need help with the macro for the button that will copy only the rows to a new sheet that fit within the range. So in the example above, pressing the button will create this in a new sheet:
A B
Name Grade
Bob 90%
June 95%
I have written a macro that copies a row to a new sheet and adds a formula to that copied row.
View 8 Replies View RelatedI want to create a macro that will allow me to create a set number of copies of a specific sheet within the workbook. I have one sheet within my workbook entitled "Tab". I want to create a macro that will ask me how many copies I want to create and then proceed to create all the copies. i.e.: select to create 4 copies, with the result being: Tab[original], Tab(2), Tab(3), Tab(4), Tab(5)
View 2 Replies View RelatedI'm looking to automate the process of repeating an excel worksheet (which is set up with various tables and formulas) for various countries.
I have a referenced list of countries set up in worksheet 1. So for example: in worksheet 2 I have a sheet set up for Albania - and I want to repeat this for another 100 countries. . Can I use the reference list of countries to auto-repeat worksheet 2 for worksheets 3 - 102 and auto-title the worksheet tabs? (E.g. Brazil, Canada, Chile..............)
I have this code that works where Column A and B from 12 sheets are copied to a "Complete" sheet where it is saved as a CSV file for import.
I'm fairly new at this and know this code could be simplified to loop through the 12 sheets instead of copying the code 12x!!
I've copied the code for the 1st 2 sheets:
Sheets("Sheet1").Select
For i = 3 To Cells(Rows.Count, 1).End(xlUp).Row
OutSH.Cells(1, outcol).Value = Cells(i, 1).Value
OutSH.Cells(2, outcol).Value = Cells(i, 2).Value
OutSH.Cells(2, outcol + 1).Value = Cells(i, 3).Value
outcol = outcol + 1
[Code] ......
I have created a macro that copies information from various cell on one sheet to another. When I run the macro the screen flickers about 5 times. Is there a way to stop.
View 5 Replies View RelatedIs it possible to have a message box show only for a specific user when a spreadsheet is opened? I have a spreadsheet that multiple people use, but only a few edit. I only want the message box to show for those that edit the form.
View 14 Replies View RelatedI've got the below code which I use to log users who opens my spreadsheet. It's a Event so runs when the spreadsheet is open with macro enabled. The spreadsheet is on a shared drive which has the prefix "K". Most users it works find but one user gets a error Message "Path or Drive" error. I got around it by adding "on error" but how do you overcome issues with drive prefixs and the drive address e.g "K" vs "\CRD2000"
Private Sub Workbook_Open()
Open ThisWorkbook.Path & "usage.log" For Append As #1
Print #1, Application.UserName, Now
Close #1
End Sub
This is probably a VBA thing, but there might be a simpler solution. Either would be grand!
Basically, I have a four sheet workbook that needs to be printed out in its entirety (no problem doing that ); however, I would like the final sheet (called "Room Data") to be printed, let's say ten times.
So basically I'd get a single print of the first three sheets and ten of the "Room Data".
Any ideas on how to do this without having to manually print the final sheet multiple times or creating ten identical sheets in the workbook?
I found the code below and it works perfectly if I want to copy all the other sheets to a master sheet. But, I need to specify specific sheets. Basically I have a workbook consisting of multiple sheets and multiple "master" sheets so I need to specify in the code which sheets it should be copying.
[Code] ........
I want to inform my users via a message box if they have not entered the previous month's information. The months are populated via a User form using a combo box selection. The months start from April through to March and are entered into the worksheet range ("aa3").
Data is entered monthly by the team. I don't know how to begin with this. I've managed to inform them when they've already entered that months information, but I don't know where to begin with this.
In my workbook I have a form that loads some information to my database. When the information is entered and the form button is pressed I want a message box to appear to give the user some information. On that message box I want there to be a button that the user has to press before the message box disappears.
View 1 Replies View RelatedI am attempting to have a pop message display when users of a certain form "X" out of the form. Below is what I came up with but it does not seem to be working:
Code:
Private Sub IntroUpdate_BeforeClose(Cancel As Boolean)
Call MsgBox("User closed the program before any formulas were updated.", vbExclamation, ".: ALERT: FM Program Tabs :.")
End Sub
Currently the above is in the code section of the form (titled: IntroUpdate).
Also if the form unloads I do not want the message displayed - only in the event that a user "X" out of the specific form titled: IntroUpdate).
how do i go about setting a message box to pop up every 10 mins or so prompting the user to close the workbook.? i want it to be as irritating as possible! iv'e had a look at ontime but cant get my brain into gear!also don't some of these timers fire even if workbook closed?
View 4 Replies View Relatedfind attached zip file . if you open the file then you can understand the problem.
I need to change cells color and text color as per user choice in Password protected sheet : (user is useing excl2000)
Kindly open attahced file i putted the note inside the file.
I'm using VBA to upload the open workbook to app.box URL which is working great! Since I'm pretty new to VBA, I can't figure out how to get Excel to display the sucess/failed message from the server to the user. I used the VBA POST upload module from this awesome tutorial, but I can't figure out how to return the message to the user. I did figure out that on the website there is an "id="after_upload_message", not sure if that works. My code is below.
[Code] ......
If cell K6= "ERROR" I need a message to pop up on screen with the message "Wrong Entry click OKAY to find, Click CANCEL to ignore". Clicking OKAY would simply go to worksheet named "MONITOR". Clicking Cancel would just clear the pop up from on screen.
View 5 Replies View RelatedI have two combo boxes: One for entering the Year, and one for the month. I can produce a message if the user leaves either box blank but I want a message to apear it the user selects a year AND month less than the current year (iYear) and current month (iMonth). I therefore need an AND statement between the two criteria but i dont know how to do it.
'....First Checks the Comboboxes arent blank then below Checks a future month/year secection is chosen
ElseIf YearBox.Value = iYear & iMonthbox < iMonth Then
MsgBox ("You may not enter Data before the current Month")
Else '...... Run main code here
I have created some vb code using the yes/no message box which is attached to a butoon on a sheet that delete's the active sheet and unhide's another sheet. I would like to know how do I by pass the builtin excel message box (the one with delete or cancel buttons) or is there a way of automatically activating the delete button on this message box.
View 2 Replies View RelatedI have a series of combo boxes which change values in a table. I have multiple versions of the same combo box on different sheets, linked to the same cell.
On ONE of the sheets where these comboboxes reside I would like to display a warning message that when changed, the following tables have also changed.
I have the message box working fine on different choices, great.
However when the combobox is changed from another sheet, the message pops up. I only want to show this box on a single sheet. I have the message box running from a copy of the drop list on the sheet specied using the worksheet_calculate function in vba.
I have attached a file. I have been receiving this message when I import a sheet. There are no functions or code on this sheet being imported. I had "cleared contents" of the sheet and it still pops up.
View 2 Replies View RelatedI have a worksheet called "PurchaseOrders" and a worksheet called "Orders."
In the "Orders" Worksheet I have a command button. When this button is clicked it writes to cells in the "PurchaseOrders" Worksheet. The cell range it writes to is N21:N1000. It basically writes an invoice number which exists in cell B6 of the "Orders" Worksheet with each number listed in order.
After it has written, when I return to the "Orders" Worksheet, if the button is clicked again but the PurchaseOrders" Worksheet N21:1000 contains an invoice, the same as "Orders" Worksheet B6 (a duplicate), I would like an error message to be returned stating "Please Create a new invoice." I already have a sub where error messages are recorded for void fields and unregistered customers.
How would I write an if statement in this sub to say:
IF Cell range in "PurchaseOrders" Worksheet (N21:N1000) does not equal the code in "Orders Worksheet (B6) please process code as normal. Else if it does please display an error message and do not proceed with processing any code? For some reason I'm having trouble naming the cell range.
I m trying to input values of an protected cell and an error dialog will display. my question is how to invoke that error dialog through vba? i have attached that error dialog for your perusal, see .jpg attachment
View 4 Replies View Related
