lukemagee Posted May 17, 2018 Report Share Posted May 17, 2018 I created a multiple choice list which unfortunately could only hold up to 9. Once it got into AA, BB, and so forth it wouldn’t work. So my solution is to just have one of the values say next page and when selected, pulls up another multiple choice box continuing the selections. I currently have it set up like this but it’s not working: Multiple Choice Box 1 if multiple choice box 1 = 9 Multiple Choice Box 2 end if if multiple choice box 2 = 9 Multiple Choice Box 3 end if Any help is appreciated. Thank you, Luke Quote Link to comment Share on other sites More sharing options...
rberq Posted May 17, 2018 Report Share Posted May 17, 2018 In what way is it not working? Do you mean the second and third boxes never appear? Are you having the multiple choice box return the TEXT of the selected item, or the VALUE of the selected item? Quote Link to comment Share on other sites More sharing options...
lukemagee Posted May 17, 2018 Author Report Share Posted May 17, 2018 Sorry it’s working now. Idk what happened but I copy and pasted it into a new macro and it worked just fine. Must have bugged out. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.