How To Add Shortcut Key Combination To Trigger To Code
Aug 20, 2012I want add a short cut key combination to trigger to code currently in the worksheet section, at the moment it is triggered by a double clck in a row. [URL]....
View 2 Replies
ADVERTISEMENT
Adjust Code From Cell Range Trigger To Button Trigger
Jul 1, 2014I have the code below that is two separate activities and I want to change the second activity from a cell trigger (Set KeyCells = Range("K42:AD42")) to a button trigger. I need to first to remain unchanged.
I'd be ok if this was just one macro that I could assign to a button but because its two and I need to write the second's to clicking a button I'm over my head.
Its occured to me while writing this that because it'll be a range of buttons I'll probably need to make each one an individual code? Is this the case? If so I may have to just keep this as it is.
Automatically Trigger Formatting Code On Drop Down Choice
Apr 6, 2008I'm building a Excel 2003 workbook that needs more than 3 conditional formats. I've tried the code given in the FAQ: Get Around Excels 3 Criteria Limit in Conditional Formatting but this only works on cells being modified directly. I've also tried the code in the post: VBA Conditional Formatting - Refresh when data changes but neither does the job I need.
I'm using a Format Control to present the user with a list of choices. When the control changes the target cell I want to apply a conditional format to that cell. This image shows the form. When the Format Control selection (in B2) is changed I want to apply conditional formating to the target cell (A2).
There will be up to 10 choices and therefore conditions.
Code To Open Shortcut Files..
Sep 14, 2008this is a bit of the code that should open a file, but the thing is tha I am trying to open a shortcut file. not a normal one. so I alway get an error that say tha tis not possible to locate the file. does any body knows how should I do to open the shortcut file?
View 4 Replies View RelatedComplex Character Combination Validation Code
Dec 15, 2009I really need a validation code for Cell B15. I realize that a macro could do this, but a validation code is what I really would need:
Cell B15 can only allow at least one of the following values, or two or more of the following values separated by '&' (Note the spaces between the digits):
I
I I
I I I
IV
IA
I IA
I I IA
IVA
or (some combination examples):
IA & I I I
I I & I I IA
I VA & I IA
If the user fails to meet these requirements, then he should get an error message telling him to try again.
VBA Code To Replicate Keyboard Shortcut Sequence?
Jul 16, 2014Is there anyway in VBA to show the key sequence Alt+Shift+F10 then c?
Trying to find an easier way to convert text to number rather than having to use the Error Box method all the time as several large worksheets.
Accumulate The Hours For An Invoice Period And Job Code Combination
Jan 28, 2010My problem is that I have a worksheet tab (RawTimeSheetData) which contains a whole series of week/timecode values for a range of people.
I want to accumulate the hours for an invoice period / job code combination. As an example in the tab InvoicePeriodSummaryTimes cell D6 i want to sum all the hours from RawTimeSheetData where both cells A6 & B6 from InvoicePeriod tab = cells D6 & E6 from the rawdata tab.
VBA Code To Create A Paste Special Values Keyboard Shortcut
Mar 20, 2009I have written a short VBA code to create a Paste Special values keyboard shortcut.
Is there a way or a place that I can put this code so that every time I open any workbook in Excel, or open Excel itself that this VBA code will be active and I can use the keyboard shortcut?
Decrease Letter And Number Combination Code By Number
Dec 21, 2012I have letter and number combination code in two collumns and they differ for 10.000 numbers:
BAM98314
BAM88314
BAM90000
BAM80000
As you can see the left code is for 10000 numbers higher. the letters are allways the same. In the event that this isn't so, if difference between codes in same row is more or less than 10000 numbers. I was thinking on making conditional formating so the cells with wrong difference would be marked red, but I do not know how to make formula for this difference.
Only Display Value If Combination In Two Columns Matches Combination In Two Other Columns
Jul 12, 2012I have a formula that I can't get to paste successfully in the forum - it keeps getting cut off?!? ... but I think I can probably simplify my explanation to get the answer I want anyway.
I need to only show the value from AUS!$H$2:$H$17 if the C2 & D2 combination are the same as the AUS!$B$2:AUS!$B$17 & $AUS!$C$2:AUS!$C$17 combination.
How To Trigger A Message Box?
Dec 17, 2007how to trigger a message box?
if i type TP123 in cell A1 i want it to trigger a message box with a comment
Can Excel Able To Trigger If Due Date Is Set
May 20, 2013I am preparing a list of calibration items that require yearly calibrated, how can I set the date and prompt me example 1 month ahead when the item is going to due soon.
View 3 Replies View RelatedConditional Formatting Using A Trigger?
Sep 17, 2013I have attached a sample work book.
What I want to achive is the colouring of the cells in columns A-L using the trigger of the "Y" character in colums J-L
So when a Y is put in column J the cells to the left and including column J change to green. Then when a Y is put into column K the cells to the left and including K turn yellow. Finally when a Y is entered in column L the cells to the left and including L turn the lovely shade of Pink. It is possible the process will go from a Y in column J to a Y in column L mising out column K but I don't suppose this will matter.
I used to have it working in office 2003 to a fashion but have not yet got my head around 2010
VBA To Trigger Event Change
Feb 26, 2014I have a chart with 2 Y axis. I am attempting to write some code that will update both axis with the same max & min value that is triggered by the combobox selection. The code will update the axis but is not triggered by the combobox selection.
[Code] ...........
Trigger Macro After 15 Seconds
Feb 22, 2009I want to trigger a macro that refreshes a pivot table but I only want to trigger the macro after 15 seconds. The reason is that I am pulling the source data from access mdb so I want only to refresh the data once the data is pulled.
View 3 Replies View RelatedSumif - Only Trigger On Certain Month
Oct 20, 2012How do I amend this formula to have it only trigger on a certain month.
=SUMIF(C:C,1,F:F)
Date Description CatCost feesTotal Balance
20/02/12 PayPal Credit 10$0.10 $0.00$0.10 $0.10
20/02/12 PayPal Credit 10$0.01 $0.00$0.01 $0.11
26/02/12 Payment 1$174.69 $4.49$170.20 $170.31
I need it to look at what month it is and then the category.
How To Trigger Macro On A Condition
Jan 25, 2014Is it possible to trigger a macro on a condition like this?
If date more than 1 week arrange date in sequence order.
Create A Automated Trigger
Apr 5, 2007I am having trouble trying to get an MS Access Query to run from MS Excel automatically.
I am trying to create an automated trigger in MS Excel that will automatically run my Access query by the times I specify in my statement.
For example: I need to run a query in Access at 9am, 12 pm and 10pm, that's it, but I believe I need to do it via Excel, I don't want the data returned to Excel, I just want Excel to execute the query at those specific times!
Drop-down Box Value To Trigger Macro
Jun 21, 2006A1 is a drop-down list, created from Data> Validation>List, which lists 3 different words (Text1, Text2, Text3). I have recorded 3 macros (Macro1, Macro2, Macro3). Here's what I want to happen:
When Text1 is selected in A1, I want Macro1 to run (same for Text2/Macro2 and Text3/Macro3). I want the user to be able to change this value as many times as they wish and have the corresponding Macro run each time. I've tried creating the appropriate code in Editor using other threads on this forum, but I can't seem to figure it out.
Function Activating Without Known Trigger
Aug 2, 2006I am encountering a strange situation with my Excel 2000. I have a public function, in a module in the VBA project associated with my workbook. But I'm not calling it from nowhere inside the code, or from other macros - it is not being referred anywhere in the workbook. Yet, after I make a slight change in code and not save my changes, when I return to the workbook and select a value from any cell with a validation-list (regardless of the sheet where it resides), that particular function is being executed!
View 9 Replies View RelatedTrigger Event Web Query
Mar 22, 2007I have already use excel web query, and set every 5 minutes auto update web.
And here is question , I want to use vba event to trigger when cell's value changed.
Unfortunately,
Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
This code didn't trigger successfully,I think that web query make cells
value changed didn't trigger the event.
Trigger Click Events Via Vba
Jun 14, 2007Is it possible, that while running code that the code can say initiate the click event on a command button on another sheet.
Say that I have a button on Sheet1 called "wkscmd_DisplayDEI"
Behind that button is obviously some code. I want to know is it possible that while some code is running ( code does not reside on the module page for Sheet1 that it can send a pseudo click to the button?
Using Letters In IF Statements To Trigger Computations?
Mar 4, 2014 i'm attempting to create a spreadsheet that will enable me to calculate the number of certain materials required to construct new rural fencing. I have 4 different 'types' of fencing each requiring different levels of materials required. For example, a Type 'A' fence, requires 5 'droppers' per 10m span of fencing, whereas a Type B requires only 1, a Type C also requires 5 - but a Type D does not require any.
Here is what I have attempted to generate so far - but is giving errors;
=IF(E42="A",((E35/10)*5),0),IF(E42="b",(E35/10),0),IF(E42="C",((E35/10)*5),0),IF(E42="d",(0),0)
Cell E35 is a fence length field to compute that number of droppers per 10m span of fencing.
Cell E42 is the cell for fence type (i.e.: A, B, C or D).
Banding Numbers Associated Trigger Points?
Mar 4, 2014We have a customer rebate in place with various levels of refund based on the quantity purchased during the year. I have used a sumproduct formula to calculate this before.
The customer used to have the following set up -
0-999 - £1.00 per unit rebate.
1000-1999 - £2.00 per unit rebate.
2000-2999 - £3.00 per unit rebate.
So if they bought 2501 units they would get a rebate of (1000*1)+(1000*2)+(501*3). However the customer has trigger points so rather than the above it is now -
0-999 - £1.00 per unit rebate.
1000-1999 - £2.00 per unit rebate.
2000-2999 - £4.00 per unit rebate if 2500 bought.
So now it would look like this - (1000*1)+(1000*2)+(501*4). However if they only bought 2499 units it would be (1000*1)+(1000*2)+(499*2).
Restricting Auto Add Row In Second Sheet To Only One Trigger
Jul 28, 2014I have cut and paste some code provided by members of this great forum to insert a row in a second worksheet at the same row number when one is inserted in the active worksheet. e.g. If I insert a new line at Row 14 in worksheet "admin" I also get a new row at Row 14 in worksheet "report".
Code is as follows:
Private Sub Worksheet_Change(ByVal Target As Range)
Set sourcebook = ThisWorkbook
Set sourcesheet = sourcebook.Worksheets("admin")
Set targetbook = ThisWorkbook
Set targetsheet = targetbook.Worksheets("report")
myRow = ActiveCell.Row
targetsheet.Activate
ActiveSheet.Rows(myRow).EntireRow.Insert
sourcesheet.Activate
End Sub
However, anything I do in worksheet "admin" triggers a new row to be inserted in "report".... If I change text in any cell, or make any changes at all, I get a new row in "report".
Is there a way to restrict this action to only a line insert?
Trigger Hyperlink Based On True Value Of IF
Oct 21, 2008I need to trigger a hyper link say "Modify" based on the "True" Value of a "IF" condition in that sheet.
We can place that "IF" condition Right next to the Hyperlink if needed. But how to do that.
the If condition is like
=if(A1=B23, Trigger Hyperlink,False)
The cells are dynamic and even the sheet is Dynamic.(they can be any cell and any sheet)
Trigger A Macro On Workbook Close?
Dec 5, 2008When I open my workbook it also opens a separate workbook and hides second book.
when I close myworkbook I want to unhide the hidden one and close it without saving.
Trigger Macro At The Start Of The Month
Feb 18, 2009is possible to trigger a macro at the start of every month. I have a fairly simple bit of VBA, but just want it to execute on the 1st of every new month.
View 3 Replies View RelatedTrigger Actions For Three Choices In A Macro
Dec 30, 2009I have a series of macros altering various workbooks and sheets. They're numbered Step1, Step2, etc. In my Step5 I have a series of Case statements in a macro, and I don't know how to get it to do what I want next. I have NOT tried running this code yet, and I'm sure I have something(s) wrong in it.
1) If the selection in DstWbk, sheet "Steps", is "01DSP" through "11DSP" the macro needs to delete specific columns in the SrcWbk, and then move to the next step (6).
2) If the selection in DstWbk, sheet "Steps", is "*DSP" the macro needs to go directly to the next step (6)
3) If the selection in DstWbk, sheet "Steps", is anything else the macro needs to flash a generic "No Data found" message and move on to Step7.
The part of the code that's throwing me begins at 'Select only the specific regional data' and ends at the "Case Else MsgBox"
Creating A Date Range Trigger
Jun 5, 2007hi i am currently trying to construct a date based maintainance sheet
i will try to explain what im trying to do
in one cell date is inputted
the next cell automatically adds +30 to generate next test date
what i am trying to do is get the sheet to
there are 4 testers so its a 3 month cycle for each ie
tester 1 jan
tester 2 feb
tester 3 march
tester 4 april
tester 1 may
tester 2 june
you get the picture? i hope
so if
cell A1 todays date
a2...................................b2......................................c2
21 jan.............................21 feb................................tester 2
inputed ...................... =A1+30
and date
formated
cell
i am trying to get the formula to tell me after the inputed date has been changed who the next tester is
i have tried using the IF command but it wont let me specify a date range ie 1 jan to 31 jan (or in the specified date codes) date range only one specific date with >= or <= which doesnt quite work properly