Description:
Microsoft Office Excel newsgroup.
|
|
|
Cell entry triggers Worksheet_SelectionChange event
|
| |
Tested in Excel 2003 fr, Excel 2007 fr, Excel 2010 beta en. When you enter any character in a cell, the Worksheet_SelectionChange event macro is fired (the target cell is still the active cell, no move after entry). Anyone heard of it ? TIA Daniel
|
|
|
Button for a Macro
|
| |
Excel 2007 is it possible to put something on the Quick Access Toolbar that will allow me to run a macro with one click?
|
|
|
select a range by cell names; vba
|
| |
I'm trying to select X rows for a sort. The first and last rows have a defined name, RSTART and RLAST. They look like this in the Define Name dialog: ='MySheet'!$15:$15 .... How do you select the rows using these names. Here's the macro output of my best shot. I can't figure out how to incorporate the second... more »
|
|
|
Copy from one worksheet to another
|
| |
I have some code that calculates how many lines I need to copy from one worksheet to another, but when I do the copy I get an errormessage. Here is part of my code: Private Sub Start_Click() Dim lastline As Integer Dim MalWb, RappWb As Workbook Workbooks.OpenText Filename:=RapportFrm.Innfil.Va lue, Origin:=xlWindows,... more »
|
|
|
Problem with copy from one worksheet to another
|
| |
I have a problem with copying from one worksheet to another. First I calculate how many lines that I need to copy, but when do the actual copy I get an error message. This is a part from my code Private Sub Start_Click() Dim lastline As Integer Dim MalWb, RappWb As Workbook Workbooks.OpenText Filename:=RapportFrm.Innfil.Va lue, Origin:=xlWindows,... more »
|
|
|
combo box value
|
| |
Where can I put the "value" direct in the properties setting instead of putting a range name? How should I input the value in "ListFillRange"?
|
|
|
Sumproduct formula works in spreadsheet, NOT VBA. Help please
|
| |
Basically, I want to replace this formula with VBA Code I can get this one to work to sum =SUMPRODUCT(--(DataTime="First day of employment (Time 1)"),--(DataPosition=N6),(Data Question1) When I change this to Count rather than Sum, my Code Evaluates as an Error =SUMPRODUCT(--(DataTime="First day of employment (Time... more »
|
|
|
Workbook_Activate() vs Workbook_Open()
|
| |
So, when a user opens my Excel file, my Visual Basic script is going to automatically fill the cells on the current sheet with predetermined values.... My question is, does it make a difference if I place my auto fill code into the Workbook_Activate() function as opposed to the Workbook_Open() function??... more »
|
|
|
simple question regarding pasting
|
| |
I have two columns. BA and BP BA has data in every row all the way down BP has data in most of the cells, but some are blank utilizing a formula of =IF(ISBLANK(BN7),"",BA7 & "," & BN7) Column BP is merely a helper column to append data together if BN is empty just leave it blank otherwise populate BP with BA and B7 data... more »
|
|
|
|
