[RESOLVED] Counting

[GADefence]

I'm trying to make a changable worksheet. I've opted to go with 3 arrays (1 1 dimensional, other is 2, other is 3 dimensional) - my current issue is . . .

Private Sub RemoveRun_Click()
If RunBox.Text = "New Run" Or RunBox.Text = "Your Runs Are" Then
Else
For CurrentRun = LBound(RunArray) To UBound(RunArray)
If RunArray(CurrentRun) = RunBox.Text Then
CurrentRun = UBound(RunArray)
DeletionRun = CurrentRun
End If
Next CurrentRun
Range("B15") = DeletionRun
End If
End Sub

Doesn't work as intended. Range("B15") is returning the string of what is in RunArray (DeletionRun = currentrun was deletionrun = runarray(currentrun) and it still had the issue)

I simply need to find a way to get the current location it is at (ex: RunArray = option 3, which would be somethingsomething) rather then (somethingsomething) as I need DeletionRun to be populated with a number and not a text. Thanks for all your help.

[Chrissy]

Posting your workbook would help... it's hard to understand your issue.

[westconn1]

i have no idea what you are trying to achieve, either from the code or your description
i do not know which which variables are your arrays (except i assume that runarray is your 1d array), or what you are using the 2 and 3 d arrays for

[GADefence]

Basically, my issue is this.

I'm trying to make it so currentrun registered the spot it is in in an array.

Then I want it go through the array, and once it notices that currentrun is the same as runbox.text (which is a drop down combolist that you need to pick something from), then it transfers the information to deletion run for the purpose of removing it from a written section.


More or less my issue is I cannot have currentrun stay a proper integer while refering it to another variable, yet the moment I make it into a cell the entire system works.

EX: CurrentRun = 5, cell A5 = 5, the next time I call it I can reference my next array to position 5.

If I do this with CurrentRun = 5, deletionrun = 5 and then reference my array(currentrun) to deletion run's position = error.

[westconn1]

where is deletionrun defined?

[GADefence]

where is deletionrun defined?

At the top of my worksheet. All of these are dimmed at the top of my work sheet, deletionrun being a long. Also tried moving it to int.