String array to a menu control

[ander99]

Hi,

I want to display my Sheet name in Excel as a menu selection for the user. How do i make a string array as a menu control? Example i got 5 sheet name and how do i make it as control?

[parthabe]

---

ander99 wrote:

Hi,

I want to display my Sheet name in Excel as a menu selection for the user.

---

You need use a drop-down control called Menu Ring in LV terms. Wire the sheet names you got by reading from the Excel file & wire the 1D Str array to the Strings[] property of that Ring control. You are done with...

[parthabe · Accepted solution]

See the attached pics.

[ander99]

Hi Parthabe,

Thank for your reply.

Regards

Ander

[ander99]

Sorry i think i phase it wrongly. Now actually i want to output a menu control to let users to choose and once user choose will output the same string as output instead of Values as 0,1,2,etc. If i use combo box, how do i link it up to make it work?

[ander99]

I got this message when i use either combo box or menu ring. Currently i'm using MS word 2003 and after i run my VI i got this error "The message filter indicated that the application is busy". Is my way of using activeX cause this?

[parthabe]

---

ander99 wrote:

If i use combo box, how do i link it up to make it work?

---

You need to use the same Strings[] property to write the Excel sheet names to it. And remember to keep the Combo Box as a Control, if you want the user to select an item from it during the run-time.