ambigous name

[dantb]

First time trying to write a frame with option buttons, keep getting error ambigous name. What I have is
Private Sub optSize_Click(Index As Integer)

This is the first line of all 3 click buttons. New at this,I cant figure out what is wrong. Thx Dan

[Aladin Akyurek]

On 2002-03-23 11:08, dantb wrote:
First time trying to write a frame with option buttons, keep getting error ambigous name. What I have is
Private Sub optSize_Click(Index As Integer)

This is the first line of all 3 click buttons. New at this,I cant figure out what is wrong. Thx Dan

Just guessing: Index is a reserved word in VB, so i or idx should work.

[Jack in the UK]

HI

To add to Aladins comments

Its just VBA clashes with what ever.

Fix:

Simple change the Sub name to something else, i try to keep simple...

BTW the Sub name and the module name can not be the same this will error ... just in case

[dantb]

Still trying, very much a beginer and trying to learn from a workbook. This is what I have.

Option Explicit
Dim PizzaSize As String
Dim PizzaCrust As String
Dim PizzaWhere As String


Private Sub Form_Load()
'Initialize pizza parameters
PizzaSize = "Small"
PizzaCrust = "Thin Crust"
PizzaWhere = "Eat In"
End Sub

Private Sub optSize_Click(Index As Integer)
'Read pizza size
PizzaSize = optSize(Index).Caption
End Sub

[Juan Pablo González]

This isn't done in VBA right ? it looks like VB, but not VBA...

[dantb]

Im in excels 2000 which comes with vba, its probaly not the full blown version

[Juan Pablo González]

This just doesn't like VBA

Private Sub Form_Load()
'Initialize pizza parameters
PizzaSize = "Small"
PizzaCrust = "Thin Crust"
PizzaWhere = "Eat In"
End Sub

Private Sub optSize_Click(Index As Integer)
'Read pizza size
PizzaSize = optSize(Index).Caption
End Sub

Why ? well, in VBA you have Userforms, not forms, they don't have a Load event, they have an Initialize event. You can't (Directly) have array of controls (the optSize looks like OptionButtons).

[dantb]

the project is under a user form, The opsize is a text box, the codes I copyed, came directely out of my workbook. dont know if where it said (index) is looking for a number or what. Just kind of lost.

[Juan Pablo González]

Yes, it is looking for a number. Which in theory should represent the index number of the Text box that has been clicked.

Are there any more TextBoxes in there ? I believe more than one have the same name, which would cause the Ambigous name error.

[dantb]

Yes I have three text boxs, which I tryed to name them the same name but it wouldnt let me. Wolking on that too !