UserForm with Combobox

[Barbu]

Hi, this is my first post, I'm new using VBA.

I'm using a userform with combobox. Combobox options are numbers from 1 to 12, what I need is define the option selected as a public or global variable, because I need to use that number in other macro.

Thanks alot !!!
<!-- / message -->

 

[Smitty]

Welcome to the Board!

You can set a Public variable in a general module, then set the variable to the ComboBox's value.

E.G. x = Me.ComboBox1.Value

HTH,

 

[Barbu]

Thank you very much Smitty it works !!!

Now I have another question, I want to use this variable "Period" as "X" number of columns in a R1C1 formula, something like this.

Public Period As Integer

Sub CIP_Report()

Range("AA2").FormulaR1C1 = "=SUM(RC[1]:RC[(X)])"

End Sub

but I don't know how can I do it

Thanks !!!

 

[Smitty]

Try:

Range("AA2").FormulaR1C1 = "=SUM(RC[1]:RC[(" & X & ")])"

 

[Barbu]

Smitty I think I didn't explain it well before, what I have define as variable is "Period" like:

Public Period As Integer

and I tryed:

Range("AA2").FormulaR1C1 = "=SUM(RC[1]:RC[(" & Period & ")])"

But I got an error '1004'

thank you very much for all your help

 

[Smitty]

Lose the Parens before and after Period, so that you only have brackets. Sorry I missed those earlier.

 

[Barbu]

thank you very much Smitty !!!! I really appreciate your help