Splitting a integer into 2's

[Dtex20]

Hi guys,

Sorry for the poor title, i had no idea how to name such a simple task

I have a number lets say "10" stored in a variable. I want to split that variable into 2x multiplication table. 2,4,6,8,10. I need to do this via VBA, i will be adding the result to a combobox.

In python i would store that 2,4,6,8,10 in a list and display it. I'm not sure of the equivalent in VBA.

Thanks for any help guys!

 

[MickG]

Maybe !!

[COLOR="Navy"]Sub[/COLOR] MG07Jun03
[COLOR="Navy"]Dim[/COLOR] c [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long,[/COLOR] n [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long[/COLOR]
 c = 10
 [COLOR="Navy"]For[/COLOR] n = 2 To c [COLOR="Navy"]Step[/COLOR] 2
    ComboBox1.AddItem n
 [COLOR="Navy"]Next[/COLOR] n
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]

Regards Mick

 

[Dtex20]

Maybe !!

[COLOR=Navy]Sub[/COLOR] MG07Jun03
[COLOR=Navy]Dim[/COLOR] c [COLOR=Navy]As[/COLOR] [COLOR=Navy]Long,[/COLOR] n [COLOR=Navy]As[/COLOR] [COLOR=Navy]Long[/COLOR]
 c = 10
 [COLOR=Navy]For[/COLOR] n = 2 To c [COLOR=Navy]Step[/COLOR] 2
    ComboBox1.AddItem n
 [COLOR=Navy]Next[/COLOR] n
[COLOR=Navy]End[/COLOR] [COLOR=Navy]Sub[/COLOR]

Regards Mick

Thank you so much!

You guys have been such a help while I've been learning VBA

 

[MickG]

You're welcome