bazza_g Posted June 18, 2008 Report Share Posted June 18, 2008 somehow I've ended up with a task to produce a spreadsheet that ideally when you click a box it brings up a question box with 4 options. Depending on which box you click then another box comes up with the next question - and so on for 3 or 4 questions. The final box just displays some fixed text based on the button clicked in the last question. The max number of options in any box will be about 10 I think How easy is that to do? Can anyone help me for beer or cheesy poofs? Link to comment Share on other sites More sharing options...
Mook Posted June 18, 2008 Report Share Posted June 18, 2008 You should be able to do it with Macros. I'll ask one of the guys at work to take a lok in the morning Link to comment Share on other sites More sharing options...
bazza_g Posted June 18, 2008 Author Report Share Posted June 18, 2008 cheers - I did investigate this VB thing on excel but its like a whole other language...! Link to comment Share on other sites More sharing options...
Mook Posted June 18, 2008 Report Share Posted June 18, 2008 It's bloody horrible! Link to comment Share on other sites More sharing options...
Teacake Posted June 19, 2008 Report Share Posted June 19, 2008 You don't happen to have InfoPath as part of your Office install, do you? It's apparently intended for this sort of thing. Link to comment Share on other sites More sharing options...
Mook Posted June 19, 2008 Report Share Posted June 19, 2008 I got our FD to take a look at this today Bazza - I even gave her a mini spec for it, but she drew a blank I'm afraid. It's take 30 mins or so to build you a runtime app that does what you need, but I guess it has to be in Excel? Link to comment Share on other sites More sharing options...
nordberg Posted June 20, 2008 Report Share Posted June 20, 2008 As s8ed says, InfoPath is specifically for this kind of thing. Link to comment Share on other sites More sharing options...
bazza_g Posted June 25, 2008 Author Report Share Posted June 25, 2008 cheers guys, I'm progressing a little with VB still - I'll get our IT guys to find out about InfoPath Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now