choose in vba

[MetLife]

Hi,

I want to use the choose function in VBA, but it doesn't seem to be working.

my code...

xx = Application.Worksheet.Choose(1, "3", "4", "5")

thanks

 

[Marcelo Branco]

Try

Either
xx = Application.Choose(1, "3", "4", "5")
or
xx = WorksheetFunction.Choose(1, "3", "4", "5")

M.

 

[MetLife]

sorry, I got mixed up...

srate1m = Application.WorksheetFunction.Choose(2 + CODE, 0.645, 0.763, 0.488, 0.561, 0.407)

 

[Marcelo Branco]

Worked for me

Code = 1
srate1m = Application.WorksheetFunction.Choose(2 + Code, 0.645, 0.763, 0.488, 0.561, 0.407)
MsgBox srate1m 'displays 0.488 as expected - the 3rd element

Probably, in your case, CODE +2 is not in the range 1 to 5. Check the value of the variable CODE

M.

 

[Fluff]

Not sure if there's a difference or not, but you can use the VBA choose function

Code = 1
srate1m = Choose(2 + Code, 0.645, 0.763, 0.488, 0.561, 0.407)
MsgBox srate1m 'displays 0.488 as expected - the 3rd element