Hi all,
I have an problem with an addin that i'am developing..
I'm using this code to point the rowsoruce of an combobox to more range names located in a sheet called "WPSett"
Everything is working well except when i set IsAddin Property to TRUE... ??
Thank you in advance.
I have an problem with an addin that i'am developing..
I'm using this code to point the rowsoruce of an combobox to more range names located in a sheet called "WPSett"
Code:
[COLOR=#333333][FONT=Arial]Private Sub SelectFSA_Change()[/FONT][/COLOR]
[COLOR=#333333][FONT=Arial]Dim src As String[/FONT][/COLOR]
[COLOR=#333333][FONT=Arial]src = Left(SelectFSA.Value, 2)[/FONT][/COLOR]
[COLOR=#333333][FONT=Arial]If SelectFSA.ListIndex >= 0 Then[/FONT][/COLOR]
[COLOR=#333333][FONT=Arial]With SelectTEST[/FONT][/COLOR]
[COLOR=#333333][FONT=Arial] .Locked = False[/FONT][/COLOR]
[COLOR=#333333][FONT=Arial] .BackStyle = fmBackStyleOpaque[/FONT][/COLOR]
[COLOR=#333333][FONT=Arial] .RowSource = ThisWorkbook.Sheets("WPSett").Range("_" & src).Address[/FONT][/COLOR]
[COLOR=#333333][FONT=Arial]End With[/FONT][/COLOR]
[COLOR=#333333][FONT=Arial]End If[/FONT][/COLOR]
[COLOR=#333333][FONT=Arial]End Sub[/FONT][/COLOR]
Everything is working well except when i set IsAddin Property to TRUE... ??
Thank you in advance.