Equivalent to a populated InputBox or pop up Listbox

[ARowbot]

Hi All,

I have a string separated by Chr(10) *alt enters. like below..

Please Login or Register  to view this content.

I am trying to get a listbox to pop up like an input box does so that I can choose which question to delete from that string. I currently have this input box but I would like it to be more rigorous so therefore that the user can Only select a question number in the string.

Please Login or Register  to view this content.

Many thanks,
ARowbot

[pjwhitfield]

Please Login or Register  to view this content.

The above will take the variable "YourStringVariable" and split it into an array called "SplitArray" before using that array to populate a listbox on Sheet1 Called Listbox1

obviously you need to create the listbox etc first and change the above to whatever your details are but that will populate it.

[ranman256]

Please Login or Register  to view this content.