Macro To Assign Task Description To New Sheet?
Jan 8, 2013
User inputs cost in a cell then clicks macro button that will run a macro that ask for a task description. The user inputs the task info that relates to the cost (i.e. weld pipe). This data is stored on a seperate sheet in the corresponding cell (cost is on sheet "hours" and task description is on sheet "task description" both in same cell. This allows a copy of the cost sheet to reflect the task description. I have tried recording macros but can't get anywhere.
View 1 Replies
ADVERTISEMENT
Jun 1, 2007
[code]...
The above is basically an action list showing who needs to do what. Each row in the list has a task and an assignee and the assignee's email address
I want a macro (that will be attached to a button or text in column H) that will copy that entire row (as well as the headers in ROW 4) and email that info via the default email application being used on the users PC (most likely to be MS outlook). i.e if i click on the button or text in column H for Task A (Row 5), an email will be sent to JB@excel.com (column G), for Task E (Row 9), an email will be sent to TB@excel.com,...etc.
I would prefer it if the info was sent as the actual message in the email instead of an excel attachment.
View 9 Replies
View Related
Mar 6, 2014
I am running excel 2010 with windows 7. I created a macro in sheet 1 and I wish to activate the macro from sheet 2 using a form button. I have entered the code below. I know how to perform this function on a more simple macro like adding names to cells. This code is a bit more complex I just dont know where to start.
Code:
Sub LoanData()
'
' LoanData Macro
[Code].....
View 3 Replies
View Related
Apr 2, 2008
how I can write code to create a button on a worksheets and then link to another subprocedure.
I tried recording a macro and this is what excel so eloquently gave me:
ActiveSheet.Buttons.Add(384.75, 60.75, 79.5, 39.75).Select
Selection.OnAction = "CreateImport"
ActiveSheet.Shapes("Button 1").Select
Selection.Characters.Text = "Parse Deposits for Import"
With Selection.Characters(Start:=1, Length:=25).Font
. Name = "Arial"
.FontStyle = "Regular"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
.TintAndShade = 0
.ThemeFont = xlThemeFontNone
End With
This works fine, my only problem is if the button that is created is actually named Button2 or 3, etc. Is there a way to assign the new button to a variable, or would it be an object? this way it wouldn't matter what it was named.
View 3 Replies
View Related
Jul 3, 2014
I'm trying to map the cases present in the sheet 1 to Sheet 2. Here the sheet2 I have highlighted the rows yellow color that needs to be updated by using excel formulas.Here the sheet should be updated with the description below mentioned along with the formulas..Highlighted cells in the sheet2 is B,C,I,J,T,U. I have designed the below condition in the same order
B cells should be updated with the reference of Sheet1 with the below condition:
Identify the "(B Value)"Claim with below condition (D Value)
C cells should be updated with the reference of Sheet1 with the below condition:
Verify whether (I Value) Mapped to the below Coverage in CAS (K value)
C cells should be updated with the reference of Sheet1 with the below condition:
Verify whether the Incident (Q value)is below for the Coverage (K Value)
J cells should be updated with the reference of Sheet1 with the below condition:
Verify the the Exposure type(P) is below for the Coverage (K)
T cells should be updated with the reference of Sheet1 with the below condition:
Verify the cost created the reserve coverage (K value) is below (N value)
U cells should be updated with the reference of Sheet1 with the below condition:
verify the line category of the payment done on the coverage
(X value of all the conditions for Sheet1 value)
View 1 Replies
View Related
Dec 5, 2012
creating an Excel invoice that would auto-populate from another Excel worksheet or file with data. The information that I would want to include are:
Company name
Name (person)
Email address
Start date
End date
Promotion description
Number sold
Price per item
Total charged
View 1 Replies
View Related
Mar 21, 2013
I am trying to write a macro that will allow me to add task to [url].... (task managing webpage) from data within excel. I could easily write a macro that emails the information to my toodledo email address, but this is not what I would like to do.ow to start the code utilizing Toodledo's API, which can be found here:
View 5 Replies
View Related
Apr 29, 2014
Ive been looking at a bunch of examples, but everything that I have tried just gives me errors. what code to use to make a vbs script to run in windows task scheduler that will...
Open "J:GroupsBSHEETSSDANew EOD.xlsm"
Run the macro named "EODPrint"
Save the workbook
and close the workbook
Leaving excel open if other instances exist.
View 9 Replies
View Related
Aug 1, 2009
Can a macro from Excel VBA create a Task in Outlook?
I would like to have Excel create a task populated with a date in a given cell in Excel.
Basically, click a button and a task is creaed in Outlook based on the date in a given cell.
Is this possible?
View 10 Replies
View Related
Apr 18, 2007
how to assign the value of whole row from one sheet to another sheet?
Worksheets("Result").Cells(count, 1).Value = Worksheets("Current").Cells(k, 1).Value
the above code assign only the specifc cell value. but i need to assign whole row
View 9 Replies
View Related
Apr 5, 2006
I have a worksheet(Shed) and the range where numbers will be entered are B3:E46. In another sheet(Location) I have a in column A "Shift #", B "Shift Bus #" C "Location". what I am attempting to do is when a bus number is entered into Shed! ie.. b3=900, d15=350 etc.... Location! would lookup ie.900 in the Shed! and match it to Location! (column B) and from there provide the cell ref in column C. So I could then print Location! that would give me in Shift # order where each Bus # the shift is assigned to.
View 13 Replies
View Related
Dec 11, 2006
This is my input for password prompt:
Sub CommandButton1_Click()
Dim wSheet As Worksheet
On Error GoTo ErrHandler
Currently, my excel is protected with a password "PSWD" when users open the file. In my vba script, I have a function that can unprotect my excel without any password input box to the users. This method is to unprotect the file and allow users to do any formating columns and rows tasks, such as add or delete cells. After users finish their job, the file will be protected back. The function is such as below:
Dim wSheet As Worksheet
For Each wSheet In Worksheets
Application.ScreenUpdating = False
If wSheet.ProtectContents = True Then
wSheet.Unprotect Password:="PSWD"
Else
My questions are:
1. How I can create a hidden sheet that has one cell populated only?
2. How can I assign the password that the user enters at the "TextBox1" (first code) to a cell of of the hidden sheet? Do I have to modify the first code?
3. For the second code, how am I going to assign the value to at the wSheet.Unprotect/Protect Password:="..." with whatever the user has previously chosen as a password that refers at the hidden sheet?
View 9 Replies
View Related
Sep 11, 2006
I written VBA code to create a new sheet and embed a command button on it. I want to assign a macro to this button but when I click on the button the assign macro button is greyed out. I have plenty of macros saved and the VBA code has finished running so why should this be?
View 7 Replies
View Related
May 17, 2014
Trying to assign this cell's value to the correct sheet tab for the current month.
Trying this:
Code:
=IF(MONTH(A3)=5,'[Wholesales 2014.xlsx]May'!$P$1,0),IF(MONTH(A3)=6,'[Wholesales 2014.xlsx]Jun'!$P$1,0)
A3 is todays date. Wholesales 2014.xlsx]May is a seprate sheet for the month of may and so forth for june.
The problem is the p1 value is empty for the Jun sheet so I get an error: #VALUE! (I assume that is why I am getting the error?)
Using:
Code:
=IF(MONTH(A3)=5,'[Wholesales 2014.xlsx]May'!$P$1,0)
By itself works just fine. I need to set this up for future use, though.
View 3 Replies
View Related
Aug 17, 2009
i have the following code for sending a worksheet to a closed workbook
View 14 Replies
View Related
Jul 21, 2009
I would like a to activate a form every time I click in a given cell. how to do this?
View 4 Replies
View Related
Apr 3, 2008
While practicing writing macros and studying the VBA code, I decided to add a button to run the macro, something I've done many times in the past. But the option to associate the new button with any macro doesn't seem to be available.
A. How can I assign a new button to a macro
and
B. How can I make the association in VBA?
View 9 Replies
View Related
Jul 7, 2007
I have several macros where I have assigned keyboard shortcuts, as below. Yet they don't work.
Sub My_FastCleanup()
' My_FastCleanup Macro
' Keyboard Shortcut: Ctrl+Shift+M
-macro stuff-
End Sub
View 9 Replies
View Related
Dec 13, 2007
From the Control Toolbox I click on the command button icon. I positon the mouse where I'd like to place the command button and draw the command button. Then right click to open the drop down menu. A few days ago in the drop down menu I had an option Assign Macro but now I don't have it anymore. How is it possible to assign macros to the command button and even better how can I get the Assign Macro option back in the drop down menu?
View 2 Replies
View Related
Feb 12, 2008
I have designed a functioning userform which transfers the data (limited or complete) into the sheet. Along with the data and at the end of each row it automatically generates 4 checkboxes and links them to 4 offset cells.
This is where I hit a dead end. I am not sure which avenue is suitable or indeed possible. I want to click any checkboxes in the first COLUMN and as a result have it change the complete ROW colorindex of the background. I did achieve this with conditional formatting but it seemed to make the empty sheet bulking when saving and I cannot alter the font size which is another goal on the 3rd column of checkboxes. Am I waffling yet?
The 3rd column checkboxes I want to have the ROW font size drop to 3pt. The 2nd and 4th currently serve no purpose i.e. trigger nothing as a result.
I don�t think I can use the checkbox_click event as the boxes are generated for me so I don�t know which number they will be. The worksheet_change event and calculate event don�t seem to register when the linked cell goes to TRUE or back to FALSE. I tried using FORMS and CONTROLS checkboxes but neither has brought me success.
I was hoping the linkedcell would trigger an event and in turn select and manipulate the entire row in which the linked cell is located�.
Due to my limited knowledge the code I have written/adapted to suit my needs may appear a little unorthodox? I hope that in itself is not a problem.
I have not managed to get the Controls Checkboxes to initalise blank. Currently they appear greyed out with a tick but fully usable? Of minor importance.
I can't attach the file because the blank sheet is 4.5MB?? so here is the main body of code from the userform. If you need anything else I will supply as required, however I can't get anyfiles under the attachment maximum of 48.8kb. My jpeg image was 108kb....
View 9 Replies
View Related
Nov 22, 2005
I have to modify 2000 files so I've written a master file that loops through a list, importing modules and forms into the 2000 files it opens and closes. On each file when open it draws a button on worksheet. I then want to assign a macro to the button called "ModifyMenu" . The code for 'Modifymenu' is imported into file_01.xls and is a unique name. It does not exist is master.xls, so no confusion.
The code for assigning the code is as follows :
Windows("file_01.xls").Activate
ActiveSheet.Shapes("Button").Select
or
Workbooks("file_01.xls").Sheets("1 B").Shapes("Button").Select
Then
Selection.OnAction = "ModifyMenu"
(This links to master.xls!ModifyMenu not file_01.xls)
Selection.OnAction = "file_01.xls!ModifyMenu"
(This fails, runtime 1004. 'Unable to set the OnAction property of the button class)
Selection.OnAction = ThisWorkbook.Name & "!ModifyMenu"
(This links to master. MAster is the active code even though 'file_01.xls' is the active worksheet)
Variations on the above seem to result in the same 1004 error or linking back to master regardless of the fact I'm trying to link to file_01.xls.
View 6 Replies
View Related
Mar 19, 2014
My macro essentially requires a deletion of the entire sheet, so I cannot run it through a button, it'd by definition be deleted. So I was thinking to run this macro through the keyboard, how to assign a keyboard key to existing macro?
View 4 Replies
View Related
Dec 3, 2008
i want to know how to assign a macro which will remove and place a number in a certain cell. so if i click and tick the box, then a certain figure will come into a cell(this will be a formulae) and when untick the the number will disappear.
View 4 Replies
View Related
Feb 24, 2013
I have several Activex buttons in sheet "Options" and I would like to automatically assign each button to the same macro "Run_Options", in order to execute the macro "Run_Options" when I do click over any button.
How can I do that with a excel macro?
View 2 Replies
View Related
Oct 22, 2009
I have a start page in the beginning of my excel workbook.
This is where i want to assign a macro to a search button.
I want the macro to search the entire workbook but only in a certain block on each worksheet.
View 9 Replies
View Related
May 30, 2014
I created a drop down list (of various Input Groups) and I need to show the selected group's responsibilities on a separate sheet; is there an easy way to do this?
View 2 Replies
View Related
Jun 9, 2013
I want to assign a macro of start time and end time on one button. I tried but its not working..
View 2 Replies
View Related
Oct 7, 2013
I have two files, a workbook and a document, and both are macro-enabled files. The workbook is my main file for my project and the document is my template. The workbook is basically my database with vba program that populate data to Word document. My word document is a template that has macros saved in a module. Aside from populating the data, workbook also create formfields on to the document and assign macro (ExitMacro).
However, i'm getting Run-time error (4210): Bad parameter message when i try to assign the macro to formfields. I noticed that this happened when the macro was saved in the module of the document. The workbook program works fine if the document macro was saved in Normal.dot, which i don't want to do.
View 3 Replies
View Related
Jan 10, 2007
I need a macro that will take a list of 42 names and 27 locations. The names are broken down into group of shifts, 1 shift, 2nd shift and 3rd shift. We need to perform audits on the 27 locations in groups of 2 people at a time. What I'd like is a macro that would take all the names by shift and assign 2 random people to a location. All 27 locations have to be audited each week (safety), and a report filled out and turned into our safety committee. I would like to post the audit sheet with the macro on our shared drive. Can anyone help me with this.
View 9 Replies
View Related
Dec 30, 2008
Created a button in a spreadsheet but cannot activate the shortcut menu that contains "assign macro." Help says select the button, right click on a handle and a shortcut menu appears with "assign macro." Not. I right clicked every handle numerous times and get the regular shortcut menu without the "assign macro" option.
View 9 Replies
View Related