I'm trying to use an input box to prompt the user to select the row containing the data they want plotted. I am having a problem with the way VBA likes to have its rows and column references formatted (as a letter?) vs. what is returned from selecting an active cell (as a number?).
Here's the example data that applies:
Book1.xlsx
The portion of the code I'm having trouble with comes just after the first If statement.
Please Login or Register to view this content.
Last edited by Niedermee; 08-18-2014 at 01:11 PM. Reason: Fixed asignments in "intStartRow" and "ActiveWorkbook.sheets"
To make this simpler, how do I change the format of the row/column variables in VBA?
The input box returns a selected cell format as Row 6 when I selected row "H". This is cell is used later in the code, but needs is to be formatted as a letter and not a number so it crashes.
Have you looked at using Cells?
If posting code please use code tags, see here.
I don't understand "using Cells".
I'm a novice at VBA and am trying to change code that originally hard coded the row assignment the same as it currently does for the 1st row.
If you want the user to select a cell/range use this.
Please Login or Register to view this content.
Now it gives me a Compile error: Object Required and highlights Parameter1 before the "="
Strange, that's the error I get if I don't use Set.
Did you change anything else?
When you got the error had you selected a range?
By the way, the reason you should use Set is because Application.InputBox with the Type set to 8 returns a Range object.
In addition to adding "Set" to the Parameter1 assignment, I needed to change the value to an address (Parameter1.address) and then used the mid function to select just the row letter (this assumes I never have any more than Z rows), but it works. See attached.
How do I mark post as Solved?
Glad it's solved.
Mind you there's no reason to use Address/Mid to get the row/column number.
In fact if you do that you may run into problems if the column goes past Z.
Instead of using Address/Mid you can use the Row and Column properties of Parameter1.
That was what my initial and ultimate goal, but couldn't figure it out. Forgive me if the answer is embedded in someone's reply, but I couldn't get it to work for me.
How do I "use the Row and Column properties of Parameter1"?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks