Set Multivalue Parameter from values Message box outputs

Set Multivalue Parameter from values Message box outputs

bronc3buster842001
Advocate Advocate
1,528 Views
22 Replies
Message 1 of 23

Set Multivalue Parameter from values Message box outputs

bronc3buster842001
Advocate
Advocate

This rule retrieves the info I want from the excel sheet. How do I take the values from the message box and make it into a multivalue parameter.

 

 

 

GoExcel.Open("C:\Users\Brian\Desktop\Book1.xlsx", "Sheet1")

For rowNumber = 5 To 37

	If Voltage = 6.3 Then

		If Not GoExcel.CellValue("B" & rowNumber) = "" Then

			MessageBox.Show(GoExcel.CellValue("A" & rowNumber))

		End If

	End If

Next

GoExcel.Close
0 Likes
1,529 Views
22 Replies
Replies (22)
Message 21 of 23

bronc3buster842001
Advocate
Advocate

What version of inventor are you using and Ill redo it so you can open the file

0 Likes
Message 22 of 23

A.Acheson
Mentor
Mentor

I think you have an issue because you are setting the list and trying to change the parameter at the same time. I would suggest having one rule to create the value list  and one to set them. Or check the workflow your using manually and try and replicate this. A video would be more helpful if you can't figure it out, this will help see where the workflow is falling down. 

If this solved a problem, please click (accept) as solution.‌‌‌‌
Or if this helped you, please, click (like)‌‌
Regards
Alan
0 Likes
Message 23 of 23

bronc3buster842001
Advocate
Advocate

Ok I serperated the rules and I think its working right now.

0 Likes