Excel 2013 :: Can't Select Shape / Dot
Apr 2, 2014I have a construction schedule that my boss wants modified. There is a pesky dot I cannot select to delete. It is on a grid line and I can only select the cells adjacent to it.
I am using 2013
ADVERTISEMENT
Excel 2013 :: Select Date Based On Userform Selection?
Apr 5, 2014I am working with DatePicker calendar. I have two userform with date entries. In one userform I will have 2 textbox to enter dates. In the other one I will have 4 dates to enter. I used to have Excel 2007 with Calendar Control and used to work fine but had to make multiple calendar to control individual Textbox in multiple Userforms.
I am looking for a way to, If a userform is selected to trigger only the textbox name that is within that userform. If I add more entries the code adds automatically the date from the previous userform in the next one.
[Code].....
I was thinking that this would work but it still adds the date to my frmdashboard userform if I am in my frmdata userform.
Is there a way to trigger only the userform that I am currently in?
Using Excel 2013.
Note: I also have a "Clear All" VB Code that will delete every entry in my userform on Initiate but I am looking to not go this path.
Excel 2013 :: Select Next Row / Extract Data From Next Sheet - Loop To Last Sheet
Feb 20, 2014I work for one half of a joint venture & am responsible for planning & expediting. The other half does purchasing. The bi-weekly PO download reports I receive are less than useful. I have already written the code to delete undesired sheets & add, format, and enter headers for a "Summary" sheet.
I need code to move to the next row, and run formulas to pull data from the next sheets, and repeat until there are no more sheets.
The number of sheets will vary from one download to the next, and the sheet names will vary from one download to the next.
Following are example formulas that need to be run on successive rows while pulling from successive sheets.
I am running Excel 2013 on Windows 8.1
Select Shape In Active Cell
Mar 30, 2014I am trying to select a shape in a cell and place a cell reference into the shape. I know the cell address, but do not know the shape reference. (The row that the cell and shape reside came from copying the row from another sheet and inserting it into the current sheet). I can not seem to come up with the correct code to accomplish this. Right now I have:
Cells(r + 1, 48).Select
ActiveCell.Shapes.Select
ActiveShapes.Formula = "$AW:" & r + 1
Where r+1 is the row where the line finally resides after insertion and "AW" is the column to the right of the cell where the shape resides.
I have tried to put the cell reference into the shape at the location where it is copied from but the reference is not dynamic and I can not seem to get it to be. Another issue that will arise is that the rows in the new sheet will probably be sorted and I question if the cell reference will follow the shape's new location.
Macro To Select Shape To Print Off
Jan 2, 2014I created a shape and named it Cheque and created a macro to print the shape as follows:
ActiveSheet.Shapes("Cheque").PrintOut
But the macro is not printing!
Excel 2013 :: Mail Merging From Excel Database To Outlook
Apr 15, 2014Using EXcel 2013, Windows 8
I have an Excel worksheet with one column being e-mail addresses. Other columns are Christian names, etc
Ideally can I create a full Mail merge with Outlook using whatever data I want. But probably just e-mail address and Christian name?
Otherwise be able to send one e-mail to all the e-mail addresses, without a major re-type.
Change Shape Text Without Selecting Shape
Mar 4, 2009when i run the below code i get an error 438 'object doesnt support this property or method'
View 2 Replies View RelatedExcel 2003 :: Rotate Text In A Shape?
Jul 29, 2012I struggle with my old excel (2003). There is a thing i have to do: put arrows from one sheet which will change its color depending on data, written in some fields. Also there is a task to put these values inside created arrows. I put values using commands:
Worksheets("Map").Shapes("COL").Select
With Selection.Characters
.Text = Range("Data!E4").Value
Arrows are drawn in different angles using drawing tool. So i need to rotate the text inside the arrows respectively to angle of the arrow rotation. So how is it possible to rotate text inside that shape?
Excel 2002 :: Activate Macro By Clicking A Shape
Feb 3, 2013I found in an old file that i triggered the macro by clicking a button! I would post a pic but i don't know how. How do I activate a macro by clicking a shape on the excel 2002 page?
View 7 Replies View RelatedExcel 2007 :: Add Textbox Onto Tilted Shape And Add Some Text
Apr 28, 2013I have a picture in my spreadsheet which slight tilted. I want to add a text box on to that shape and add some text but i want the text to be angled the same shape as my picture.
If I create and rotate my text box manually, the default rotation makes it rotate slight to much.
I was hoping if I could add a custom drawing of a text box so the text can be the same a picture.
Excel 2010 :: Adding Colored Shape (rectangle) To Footer?
Dec 19, 2012I need to add a colored rectangle or box to a page footer in 2010 Excel.
View 2 Replies View RelatedCreate Excel Shape From MapInfo *OR* Make Picture Background Transparent?
Aug 13, 2008I'm trying to make a map of 14 regions where each region changes brightness depending on values in the worksheets. I think I've got this bit sorted. I'm planning on creating the map using a collection of tessellated shapes or images, and using VBA to alter the properties of each one to create a dynamic map.
The output of the individual maps from MapInfo, our GIS software, is in .png or .jpg. format, and come with a white background. Is there any way to either make the background transparent so multiple shapes can be tessellated effectively, or a way to crop the image to the area's border?
Either that, or does someone know a way to output from MapInfo in such a way to make this possible? (Granted, it's a long shot, but you can't blame a guy for trying...)
Excel 2013 :: Average Readings Per Day
Jul 2, 2014Working in Excel 2013......... I take 3 readings per day, I would like to see the daily average per day
In cases where the data is blank or "0", just average the 2 readings.
Sample Data
Date Speed
6/1/20142560
6/1/20142550
6/1/20142558
6/2/20142554
6/2/20142537
6/2/20142532
[Code] ..........
Excel 2013 :: No Column Headers?
Nov 28, 2013My and a work college needed to combine our separate excel worksheets into a single document.
Office 2013 didn't have a function to "import sheet from file" so we used open office to import my .xlsx worksheets.
After we finished importing we exported the final workbook as .xls (so I could open it).
After opening the workbook on my pc (excel 2013) i notice some of the sheets no longer have column headers, but the row headings still exists. (No ABCD, only 1234)
Also I am unable to use features such as "Freeze Pane"
I suspect this was caused by importing and exporting through open office?
Excel 2013 :: Save Workbook To PDF And Name By The Value In A3?
Dec 18, 2013Tried a macro with no luck, I want to save workbook to PDF and have it named by the value in A3. I want the Dialog box to pop up so I pick the folder?
View 6 Replies View RelatedExcel 2013 :: Add In Buttons On The Ribbon?
Jun 24, 2014I installed excel 2013, but I don't find the (VBA) buttons on the ribbon, since.
Is there a need to install an add in / or activate an add in?
The macro's are on the ribbon on the tab VIEW.
I expect to find the buttons on that place also.
Excel 2013 :: How To Activate Developer Tab
Aug 21, 2014How to activate Developer Tab in Excel 2013.
View 1 Replies View RelatedExcel 2013 :: VBA - Save As (Get Filename)
May 6, 2013I'd like to record a macro that allows me to take the current file "file.csv" and save it as "file.xlsx"
I can't get the variable right (just messing around in VBA to have it get the file name and save it as a different format (csv to xlsx)
I've tried:
Function GetFullName() As String GetFullName = ThisWorkbook.FullName End Function
Excel 2013 :: VBA Connection To Access?
May 18, 2013I currently have a workbook that has VBA functions that calculates values by looping through large amounts of data in a few large excel sheets. I want to transfer the data from these sheets into Access and then bring data into the VBA code via an array from the data in Access rather than the array being populated from the data in excel as it currently is. How to create the connection. The access DB will be situated in a public directory on a server. How to create the connection string and then how I call the data from Access? I have just downloaded Office 2013.
View 9 Replies View RelatedExcel 2013 :: Insert New Row But Keep Formula?
May 29, 2013I have a complicated spreadsheet with several columns. Some columns B, D, E, F, M come from calculations on other columns or are columns copied from other worksheets within the same workbook.
I have another column C which is generated entirely off a macro with no input from the user.
I insert a row at line 8 (see above). However its just a blankrow and the formula highlighted in E2 does not show in E8 but it does appear for E9. I'd need that formula to be in E8.
My dilemma is how to insert a row and have it copy the formula from too.
I'd like to avoid copying another row into it and editing data. Other thing to avoid is putting all new rows at the end of the spreadsheet if possible. Has to be in the middle of the existing table.
I have Excel 2010 or 2013.
Excel 2013 :: How To Use VBA Code Cleaner
Jun 1, 2013VBA Code Cleaner
I just can't seem to figure out how to use the Code Cleaner, after installing it I can't find any option to use it :S
I'm using Excel 2013 and W8 (if that's relevant).
Why does importing and exporting the code reduces the size? What kind of "junk" is stored and why? and when?
Excel 2013 :: How To Add Date Range
Mar 4, 2014I have a big spreadsheet with IT / Finance data. Below is the formula, I currently have. I am summing column Y in Tab Savings Data Detail, where column A does not equal Parent, and The Value in Column AK on the Savings data details tab matches the value in current tab for cell B26 and where column G on the savings detail tab equals Transition to IT. I am adding that value to the second sumifs statement essentially the values in column X on the savings detail tab with the same criteria.
Now I need to add to each of these formulas. I need to sum only the values where the date value in column W on the data details tab is greater than or equal to 01/01/2013 and less than or equal to 12/31/2013
find the easiest way?
=SUMIFS('savings data details'!$Y:$Y,'savings data details'!$A:$A,"Parent",'savings data details'!$AK:$AK,$B26,'savings data details'!$G:$G,"Transition to IT")+
SUMIFS('savings data details'!$X:$X,'savings data details'!$A:$A,"Parent",'savings data details'!$AK:$AK,$B26,'savings data details'!$G:$G,"Transition to IT")
Excel 2010 :: VBA Code To Automatically Change Colour Shape Based On Cell Value
Mar 2, 2012I have a peice of code that i know is inefficient and it is in danger of becoming too large. I have a spreadsheet that has circles aligned to each cell. There are around 100 in total. The code changes the colour of the shape based on the cell value in which it sits. However, the code needs changing and also it does not automatically update the colour shape even though the cell value changes. I have to manually select a cell and then the formula bar and then press return for it to update.
I am using excel 2010.
This is the code i am using for each shape.
Code:
If Range("n12").Value = text Then
ActiveSheet.Shapes("Oval 250").Fill.ForeColor.RGB = RGB(255, 255, 255)
End If
[Code]....
Excel 2013 :: Date Stamp Modified Row
Apr 3, 2014Looking to add automatic date stamp to a column of cells each time their corresponding row or specific cell in that row is modified.
I'm using Excel 2013.
Excel 2013 :: Retrieve AutoFilter Criteria VBA
Jul 20, 2014Is it possible to retrieve an arrary of the autofilter criteria. I know this is possible in pre 2007 but with 2007 onwards I can't find a way of doing it.
I know I can get all the available items in a list by using the scripting.dictionary and also by using the visible cells I could see what could be filtered but that is not really accurate for what I want.
E.G.
If I have multiple columns and look at the filtered information in one column I can retrieve an array of the visible cells from that column but that is not necessarily the criteria that is in the column. i.E. If another column has a filter rows may be filtered that would have otherwise been visible.
Excel 2013 :: Chart Label Not Displaying?
Jun 8, 2014I have a workbook, which I use for different departments that displays a number of different pie charts and I have found that a particular pie chart omits a specific label repeatedly. The pie chart displays the wedge within the chart itself, but does not display the label. At the moment I have data labels with percentages. All other labels display, of which there are 7. I found a solution that fixes the problem each time it arises and that is to select Chart Tools/Format/Series 1 data labels and then Format Selection. When I then select any data label, I click on "Clone Current Label" and the missing label appears with the correct percentage amount. I use the workbook for multiple uses and rather than have it present as a template (*.xltm), it is a macro-enabled spreadsheet (*.xlsm). Could this be related to the problem?
View 2 Replies View RelatedExcel 2013 :: Conditional Formatting For Image?
May 12, 2014What I'm looking to do in Excel 2013 is have it so a specified cell loads an image based on the results of a range of cells.
For example:
If cell B1 = red
and cell B2 = up
and cell B3 = yes
then cell A5 shows image X.
But then have it be comprehensive enough to do
If cell B1 = green
and cell B2 = down
and cell B3 = no
then cell A5 shows image Y.
My hangups are trying to get different images to load in the same cell. Also, all the examples of this I've found are pulling from one cell where I need it to display an image based on the results of multiple cells.
Excel 2013 :: Macro To Update New Sheet?
Jun 23, 2014I've got a spreadsheet that pulls data from a SQL server.
I'm looking to have a button on the first sheet that extracts the data from SQL and inserts it into sheet 2 of spreadsheet. The data connection from SqL is working fine but when I click on the button sheet 2 is blank.
Excel 2013 :: Placing Date Value To 3 Different Groups
Jul 11, 2014I am rather new to excel and currently using excel 2013.
I have a worksheet with column A ( data group) Column B ( Sent date with MM/DD/YY) , Column C Aged Group {using this formula =IF(B2="","",(TODAY()-B2))} , Column D status ( if the record is open or close).
I would like to create a table that can segregate the data group and how many days it has already aged. And then group them with different aged group. Refer to the attached screenshot.
From:-
Data GroupSent Date AgedStatus
Quotation 06/06/1435Open
Invoice 07/11/140Open
invoice 05/01/1471Open
PO 07/01/1410Open
PO 07/05/146Open
SO 06/30/1411Open
Quotation 05/18/1454Open
SO 05/05/1467Open
Cash Note 07/03/148Close
To:-
Data Group0-15 15-3030 above
Quotation
Invoice
PO
SO
Cash Note
testtest.xlsx
Excel 2013 :: AutoFill Formula Down A Column
Dec 9, 2013I am trying to auto fill this formula down a column but it doesn't keep the C4,D4,E4...ETC to stay constant
I manually did these two correct ones
=SUM(C5*C4+D5*D4+E5*E4+F5*F4+G5*G4+H5*H4+I5*I4+J5*J4+K5*K4+L5*L4+M5*M4+N5*N4
+O5*O4+P5*P4+Q5*Q4+R5*R4+S5*S4+T5*T4+U5*U4+V5*V4+W5*W4+X5*X4+Y5*Y4+Z5*Z4+AA5*AA4)
=SUM(C6*C4+D6*D4+E6*E4+F6*F4+G6*G4+H6*H4+I6*I4+J6*J4+K6*K4+L6*L4+M6*M4+N6*N4
+O6*O4+P6*P4+Q6*Q4+R6*R4+S6*S4+T6*T4+U6*U4+V6*V4+W6*W4+X6*X4+Y6*Y4+Z6*Z4+AA6*AA4)
when I drag it down it incorrectly looks like this:
=SUM(C7*C6+D7*D6+E7*E6+F7*F6+G7*G6+H7*H6+I7*I6+J7*J6+K7*K6+L7*L6+M7*M6+N7*N6
+O7*O6+P7*P6+Q7*Q6+R7*R6+S7*S6+T7*T6+U7*U6+V7*V6+W7*W6+X7*X6+Y7*Y6+Z7*Z6+AA7*AA6)
I want C6,D6,E6 to be C4,D4,E4 ETC