aiki202
Member
I cannot get a Microsoft Forms 2.0 activex listbox to populate from VBA code. I am using RSView32 version 7.4. I can get text to populate in it from a command button, but not from VBA. Here is my code that adds a blank line, but no text to the listbox:
Dim tagTemp_Ingredient As tag
Set tagTemp_Ingredient = gTagDb("RECIPE\Temp_Ingredient")
tagTemp_Ingredient.Value = strRecipeValues(1) 'this string variable is populated through other code, I checked and it always
'contains a value
gCommand.Execute ("Invoke Admin.ListBox1.AddItem(Temp_Ingredient)")
Set tagTemp_Ingredient = Nothing
I do not think I can populate the listbox from the invoke command in VBA with a VBA native value such as strRecipeValues(1) (string array). I think I need to use a tag. I have the Temp_Ingredient tag assigned to the value parameter in the ListBox1 properties.
Thanks
Dim tagTemp_Ingredient As tag
Set tagTemp_Ingredient = gTagDb("RECIPE\Temp_Ingredient")
tagTemp_Ingredient.Value = strRecipeValues(1) 'this string variable is populated through other code, I checked and it always
'contains a value
gCommand.Execute ("Invoke Admin.ListBox1.AddItem(Temp_Ingredient)")
Set tagTemp_Ingredient = Nothing
I do not think I can populate the listbox from the invoke command in VBA with a VBA native value such as strRecipeValues(1) (string array). I think I need to use a tag. I have the Temp_Ingredient tag assigned to the value parameter in the ListBox1 properties.
Thanks