SirJB7,
Thank you for your help. You hit the nail on the head. The default value for vbCancel is 2, so I simply removed the line of code:
RowN = vbCancel
Since the field was either blank or 0 the cancel button still functions and the macro exits without issue.
Thank you again for your...
I have the following code. It's purpose is to allow users to insert any number of rows that they wish using an input box. However, when you insert, "2", the macro does nothing. Just wondering what simple bit of code I'm overlooking to make this work. It's blowing my mind right now that 1, 3...
Good morning all,
I apologize, but my knowledge of VBA programming is slim to none. But, I am hoping you can help solve this simple question for me.
I am trying to make a macro that brings the user to a sheet with the same workbook based on a value in a cell.
For example. I have a combo...
Figured it out ... here's an example.
'If Range("H11") = "!!!" Then
ActiveSheet.ChartObjects("Chart 4").Activate
With ActiveChart.SeriesCollection(1).Trendlines(1).Format.Line
.BeginArrowheadLength = msoArrowheadLong
.BeginArrowheadStyle = msoArrowheadTriangle
.BeginArrowheadWidth =...
Good morning everyone,
I am trying to simplify a large group of bubble charts that my company has been using. The charts compare a clients March data to their September data and draw a trend line using the "Oval Arrow" as the start point and the "Arrow" as the end point. The problem is, that...
First off I just wanted to say thank you to Chandoo, and many others that post on this site for helping me greatly expand my understanding of Excel of the last month since I was introduced to this site.
Second, I just had a quick thought for a site enhancement. I love many of your articles...