-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
shape objects
-
Arrow shape line colour depending on cell
Hi there, I would like an arrow to show if cell H107 does not equal zero. I'm not even sure if I'm going in the right direction with this VBA code. Can anyone help please? Private Sub Worksheet_Change(ByVal Target As Range) If Range("h107") = 0 Then...- tlc53
- Thread
- Replies: 5
- Forum: Excel Questions
-
D
force refresh of a Text Box (Shape) displaying text
Hi gang, I had a frustrating problem with a shape on my worksheet. It is a Text Box Shape (not a userform type) and it is supposed to display text from a specific cell. The cell contains an INDEX formula, so the contents change based on a scrollbar control elsewhere. My problem was, the...- destructa
- Thread
- Replies: 0
- Forum: Excel Questions
-
J
Referencing an object containing a macro while that macro is running
Hello! I'm using a shape to contain a delete function for a particular row of data. Since there are multiple delete shapes cooresponding to different rows, I need to use the activated shape's position data to determine which row needs to be deleted. I can't figure out how to call the shape...- jsireci
- Thread
- Replies: 2
- Forum: Excel Questions
-
Copy/Paste Shapes or Group of Shapes
Hello! I'm using Excel 2007 and have mid level skills with VBA. I'm trying to make a flow-chart type of report with text boxes and arrows connecting them using VBA. Since there are several pieces of data for each point on the flow chart, I'm thinking the best way is to have a series of...- joebbshop
- Thread
- Replies: 6
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Finding issue in If elseif else with For each Loop
- Started by Arunachaljois
- Replies: 57
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please... -
VBA to copy certain columns from multiple workbooks with multiple worksheet based on criteria into master workbook
- Started by nathanmav
- Replies: 51
Hi everyone, I would like to ask for help about the code I found and I tried to modify it but I'm not lucky to make it work. I have a total of... -
Frequent Text - Duplicates
- Started by SaraWitch
- Replies: 30
Hello all, I'm using the Index, Mode and Match array formula to show the most frequently repeated text. However, I wonder if there's a formula... -
Timer in VBA - Stop, Start, Pause and Reset
- Started by Anton1999
- Replies: 28
[CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub... -
how to updates multiple rows in muliselect listbox
- Started by jaym6939
- Replies: 26
Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code... -
Multiple Case statements
- Started by davidausten
- Replies: 26
Im using a combo box to select the option. The thing I am having trouble with is that if you select the second case statement from the list (they...