how to set combobox of a cell in Excel

[alii001]

generally ,it is quite easy to write or read data into or from excel files by labview, but today I need to set the dropdown choices of a cell by labview and it seems it is a little difficult .

what I need is as below:

for example,I want to set the 3 dropdowm choices by labview to a cell,what shall I do?

thank you!

[Emna20]

hi,

you find below solution for your topic :

Best Regards . 

Kudos are welcome .

[PsyenceFact]

@Emna20 I think the OP wants to use LabVIEW to create a combobox in Excel, not to populate a combobox on a LabVIEW FP.

@alii001 In Excel, do you mean a form control Developer - Insert - Combo Box (Form Control), an ActiveX control Developer - Insert - Combo Box (ActiveX Control) or the drop-down list available from the right-click menu of an individual cell, sometimes called a data validation list?

[PsyenceFact]

This might be useful if you're trying to use a data validation list.  A description of the parameters for the Validation.Add method can be found on the Microsoft web site.

[Emna20 · Accepted solution]

hi ,

add (true to wait until printing completed ) and (true to Save changes ) .

[alii001]

Thank you! thank you ! I have tried for several days, but got no answer, you are really kindheart and forums.ni is really a great place.

[alii001]

Thank you! thank you !

I have tried for several days of it, but got no answer.

you are really kindheart and forums.ni is really a great place.

thank you！

---

@PsyenceFact  已写:

This might be useful if you're trying to use a data validation list.  A description of the parameters for the Validation.Add method can be found on the Microsoft web site.

---

[PsyenceFact]

You're very welcome! (As are Kudos )

Andy