Excel Shapes And Mouse Rollover

Jul 25, 2014

Is it possible to create a piece of VBA that displays a comment box when a user rolls over a specific shape in Excel?

View 1 Replies


Rollover Hyperlink On A Cell Already Got Text In?

Apr 25, 2014

I have cells which already contain text, which I need to keep. But I want to add a rollover hyperlink to make them changes colour when the mouse hovers over them.

unfortunately the only way I know how to do this is to add a formula to the cells in question (mid programming) but I cant because that will erase the text I already have.

View 1 Replies View Related

Creating Shapes (Rectangles And Shapes) From Input Cells?

Aug 30, 2013

Im trying to create shapes Rectangles and Squares with different colours within an excel sheet, where the length and height of the shapes is generated by input values.

Also is it possible to create 3D shapes, again where the size of the shap is generated by input cell values.

View 1 Replies View Related

Excel VBA To Save PPT Shapes As PNG Images

May 29, 2014

I have an Excel (.xlsm) that opens an existing PPT and uses VBA to modify several slides.

There are several shapes on each slide and my .xlsm has VBA that modifies those shapes.

(The slides have designs on them for different size business cards which get filled in with spreadsheet names,...)

Now I want to "select all" the shapes on a slide as a "group"(not sure that term is correct). Then I want to export that group as a .PNG image file. Save location can be the same folder location of the .xlsm file (doesn't really matter).

This is different than exporting each slide as a .PNG.(which I can already do). In this case the business card designs on each slide are different sizes. So I need the images to be just the size of the "group" on that slide.

The VBA code is within the .xlsm file (not the PPT)

Several posts show VBA code for within the .pptm file that works fine if using just a PPT

However that code doesn't seem to work when I put it in the .xlsm file to drive the image creation from Excel.

PC with latest of all software.

View 1 Replies View Related

Number Keyboard In Excel Shapes?

Jun 7, 2014

I would like to use Shapes in excel, instead using userform as the code below.In this userform, it has command buttons for the numbers and the a text box to show the numbers.How can I do it, using square shapes for numbers and another rectangle shape, to show the written numbers.I would like to create a number keyboard using "shapes".


View 2 Replies View Related

Excel Macros To Zoom In And Out Shapes

Aug 10, 2014

I am struggling to get a macro code for zooming in and out the shapes. I have a macro which fulfill half of my requirement. By assigning the below macro to the shape I am able to increase the current size to double by clicking on the shape however I need the same macro should retain the original size upon second click.

Here is my code to increase the size.

[Code] .....

"The requirement: Once after assigning the macro, on first click it should double the shape size and on second click it should retain the original size."

View 5 Replies View Related

Rotating Group Of Shapes In Excel VBA

Feb 4, 2014

I did use the solution in a thread by Andy to make a picture or shape rotate. It works perfectly as a standalone. With this I mean all the information on the same sheet as per example in the file 901259.

I'am using it to rotate a dial. The problem is instead of using the value from the sheet itself I link the scrollbar to a cell on a different sheet in the same workbook. There some calculations are done and the value which makes the dial rotate is linked to that sheet. The dial however is on another sheet.

The calculations are almost displayed realtime but the dial is lagging. How would I go about to "solve" this lagging.

View 6 Replies View Related

VBA Code - Creating And Moving Shapes In Excel

Mar 9, 2014

1.) Create shapes (customize oval shape), I was able to create one but I think the code needs improvement to have the shape a fixed name. - see attached excel file.

2.) Move shapes into corresponding cell. Example: (Oval shape1, should be in cell g6). - see attached excel file.

Customize Heatmap creation.xlsm

View 1 Replies View Related

Smart Generation Of Coordinates For Excel Shapes VBA

Sep 5, 2013

I'm using Excel to create a flowchart from a configuration sheet. I'm not manually entering the coordinates. Instead, I draw the start step in a set location. The next step(s) that's connected to the first step is placed directly below the start step. if there's more than one step connected to the start step, it's placed at the same y-coordinate but shifted along the x-axis.

The problem I'm running into here is this: say I have three steps connected to the start step and three further steps connected to the first of the three connected to the start step, how can I keep track of this and shift the other two steps connected to the start step along the x-axis so they're not positioned above the four steps below the first step (and as such, in the same location as other steps)? I'm not sure if my description is particularly clear or not so I've attached a drawing that will hopefully clear things up.

Is there any way of giving Excel shapes a "weight" so that other shapes won't line up on top of them?

View 3 Replies View Related

Excel 2007 :: Add Shapes In Range Of Cells To ShapeRange

Feb 3, 2012

Using Excel 2007.

I have shapes in 3 different rnages of cells on a cell worksheet:
R1 = $D$5:$D & lngRows (row=32)
R2 = $G$5:$G & lngRows (row = 51)
R3 = $M$5:$M & lngRows (row = 50)

I need to set the properties of the shapes in each range differently The shapes in R1 are Left + 46 But the shapes in the other 2 ranges need to be just left My problem is in this bit


'Set properties for each shape in ShapeRange
For Each sh In ws.Shapes

I need to be able to set properties for each range separately instead of the entire sheet. Full code below (only Range $D at the moment - works)


Option Explicit
Sub AddShape3()
'Purpose: Add small rectangles to database table/fields for
' brainstorming and documenting relationships and queries


View 2 Replies View Related

Excel 2007 :: Change Text In A Group Of Shapes?

Jun 22, 2012

Ii have a UserForm with a ComboBox in it. the selections in the box are


I have 7 shapes in Worksheets("Interface") and renamed each shape caution1 through caution7

What i need is when i click on continue in my userform each shape will change according to the selection.

if 5 is selected all caution shapes will read, Caution flag is out 5 minute break
if 10 is selected all caution shapes will read, Caution flag is out 10 minute break
if 15 is selected all caution shapes will read, Caution flag is out 15 minute break
and so on

excel 2007 btw

View 3 Replies View Related

Excel 2007 :: Default Settings For Drawing Shapes?

Jun 14, 2013

how to change the default settings for shapes in Excel 2007? I select a line tool and it is a blue color and I would like to have its default as black

View 6 Replies View Related

Excel 2007 :: Rotating 3D Chart Using Mouse Events?

Dec 27, 2012

I'm using Excel 2007 and I have a reasonable level of experience with VBA coding in normal / object modules, but I have no experience with class modules or events ... so I do not have a good command on what goes into a normal module vice a class module if I want to use mouse events to rotate a chart.

I am looking to rotate a chart ... Since I am not allowed to post a file, I will give the 3D array here:



I have placed into a normal module the following code (based on what I was able to pick up from MSDN):

Dim myClassModule As New EventClassModule
Sub InitializeChart()
Set myClassModule.myChartClass = Worksheets(1).ChartObjects(1).Chart
End Sub

And I have placed the following code into a class module named EventClassModule (also based on what I was able to pick up from MSDN):

Public WithEvents myChartClass As Chart

I want to rotate the chart by using click and drag, and, if possible, I'd also like to be able to zoom in and out via some method (say a mouse wheel event).

In the following link, a guy has done a beautiful job of enabling scatter plot rotation using scroll bars, but I'd like to be able to use mouse events instead:

3d scatter plot for MS Excel (VBA macro)

View 2 Replies View Related

Excel 2013 :: Disable Ctrl+Mouse Wheel?

Apr 8, 2014

Is there any method to disable Ctrl + mouse wheel function in excel 2013, actually I want to disable zoom in and out functionality but don't want to disable normal scrolling.

View 2 Replies View Related

Excel 2007 :: Pop Up Picture When Mouse Move To Object In Sheet

Nov 10, 2012

i am totally new in excel and i am using excel 2007, my question is : how can i create an object in an excel sheet, so that when the mouse cursor move to it, it pops up anohter image?

View 4 Replies View Related

Excel 2007 :: Mouse Wheel Scroll Function Doesn't Work

Feb 8, 2012

I'm using Excel 2007. When I try to scroll with the mouse wheel, it doesn't do anything. If I hold down the control key and scroll with the mouse, it zooms in and out. So that works fine, but I can't do the basic scrolling up and down the document with the mouse wheel. There is no "Tools, Options" menu in 2007 so I don't even know where to find this type of option. The options available from the Office button are completely different.

View 4 Replies View Related

Disable Middle-mouse-click Scroll On Inherited Excel File

May 7, 2014

I've just inherited a load of Excel files I need to continue using, but my predecessor has done something that disables the middle-click scroll ability.

I can still scroll up and down by turning the wheel, but I want to be able to click it and scroll in all directions at speed - I didn't realise how much I used this until I couldn't. Can't see anything in the VBA sheet properties, and they are all .xlsx files. Nothing leaps out of the settings either. If I create a new file or a file of mine within the same session, they work fine.

View 1 Replies View Related

Excel 2007 :: Display And Hide Image On Sheet On Mouse Hover On Cell?

Oct 6, 2013

In excel 2007, I have an embedded image on a sheet which I want to make it hidden by default. When someone hovers over a particular cell say cell B3, then image should be displayed below this cell (sort of hyperlinking) and when the cursor or activell cell is not in B3 it should be hidden again. What steps/technique/VBA code will make it happen ?

View 3 Replies View Related

VBA With Shapes

Dec 3, 2008

I have a macro that opens Word pastes data in from Excel,

I want to be able to paste an arrowed line that I have drawn, also if it changes, I want it to reflect that change.

Here's the
Item("Direction1").Range.InsertAfter Worksheets("BSID").Range("Line3").Value

I have my bookmark in Word setup, I'm guessing that instead of a cell ref I need the name of the Line, which is "Line 3" in this case.

I ran a recorded macro and copied and pasted the line and instead of "Range" I got "Shapes" so I assumed that I just needed to change these words but no joy.

View 9 Replies View Related

Working With Shapes

Mar 24, 2009

Where do I find a tutorial or examples to show me how to create bars for gantt chart in excel, based on date values?

View 14 Replies View Related

How To Remove All Shapes

Nov 17, 2009

i have an excel file for using my manufacture planning. i dont know why but there was created too many TextBoxes(but its shapes)

I'm giving my excel file , you can see what i'm talking about at G column and 193. field
if you can solve this problem, i will be pleasure to you

View 10 Replies View Related

Deleting Shapes In VBA

Sep 18, 2012

I have some shapes on a worksheet that need deleting on change of a combo box. Unfortunately I'm unable to use the below code as not all the shapes need deleting, just the ones that are named in a table on another worksheet.

For Each s In ActiveSheet.Shapes
Next s

Also not all the shapes named in the table will be on the worksheet as this depends on what is selected from the combo box.

View 2 Replies View Related

Replacing Shapes With VBA

Aug 30, 2009

I am a not too good programmer, but I construct chemotherapy regimens for my medical department. They are used to minimise the risk of wrong dosing to patients, etc. Every regimen is an .xlt file, and about a third of them (there are about 100) generate, in addition to pharmaceutical prescription, automatic letters to patients (for those regimens where patients administer oral dosing at home).

These patient-letters have the hospital's logo on them (the logo is a "shape").

However, the problem is that another hospital also wants to use my system. So I will have to replace all these logos with the other hospital's. I would like to do this in an automated way. I have received the other hospital's logo also as a shape.

I have already constructed a data-inserting macro in a separate file. This macro systematically opens each xlt file and replaces the text in key locations according to the file the macro is in (geographical names, etc.).

Is it possible to automatically replace the logo-shapes in a similar way, with these additional facts/wishes in mind:

1. There is always only one type of shape (a logo) in the xlt files.

2. Even though the shapes are exactly the same, it is possible the names are different.

3. The exact location for the shape is different in each xlt file, so I'd like the replacement to get the same top left coordinate as the one it replaces.

I have constructed 2 different files with the same data-inserting macro, each containing one of the logos (so I can change back to my own hospital) and geographic data. When the data-inserting macro is used, I'd like it to identify the shape in the data-inserting file (there's only one shape in this file), copy it, then identify the shape(s) in the present xlt file, and then replace these, in the exact same location.

View 9 Replies View Related

Shapes With No Macro

Jul 10, 2006

I have a shape that will have no macro. How do I prevent this shape
from being selected and prevent the message that no macro can be found,
when it is clicked?

With shapes that do have macros how do I disable them ?
How do I keep them visible but not have the mouse cursor change on mouse
over and not have the macro run on a mouse click.

I tried to use Enabled = false but apparently that property cannot be used
for a shape.

I need to toggle between enabled and disabled.

View 9 Replies View Related

Delete Shapes On Specified Row

Jan 5, 2008

I have some drop down control boxes in rows that I want to be able to delete using a macro. If highlight the rown and use Edit, Delete, the data is gone but the controls are still there. How can I delete this using a macro?

View 3 Replies View Related

Drawing Circles And Other Shapes?

Jun 16, 2013

I want to draw circles from 3 points and other geometrical shapes. The points will be given from clicks on the background picture.

View 1 Replies View Related

Auto Shapes : Areas

Apr 23, 2008

I'm trying to calculate the area of a Freeform shape.

Is this already stored somewhere e.g a shape property?

If not is there a macro available to do this?

View 12 Replies View Related

Create Hyperlinks With Shapes

Feb 9, 2010

This code finds and matches the Text value of a Shape to the value of a cell on seperate worksheets within the same workbook.

View 9 Replies View Related

VBA To Ungroup All Shapes On A Page

Feb 23, 2007

I need code to do this: When I select a range of cells, say E20:H24 then hit a button the code behind the button would ungroup all the shapes in that area. So if I have grouped shapes elsewhere, they would be uneffected.

View 9 Replies View Related

Selecting Group Name For Shapes

Mar 5, 2007

is there a way to select the group of the shape instead of a single shape i've tried .onAction and Application.Caller to do this ..but this is giving me the single shape that i clicked on instead of the whole group.'

View 9 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved