Replies

I would say that Hans got it correct . I thought about the size issue and decided that while it would taste the same, it was a decision that needed to be made and was thus, a different (just) salad.

Jezza is correct – I do normally get a diet pepsi – but no ice (however, I do get the choice of ‘normal’, ‘with lemon’ or ‘with lime’). Finally, the dog is at home (in the garden) and the salad is eaten at work, so those issues don’t come in to it.

I think i may have to start posing puzzles / comments / posts with fictious information to stop Jezza getting a complete picture of me.

… and to finally close off one of my most successful (hyperbole at its worst) puzzles, the answer is …

Solenoid Robots as per here

Again, i cannot remember if they actually made that noise but that was the noise that all the kids at school were impersonating.

Just call me on my cell …

Well, it seem that you have found the theme song [bonus chocky bar for you]

here is a direct link (realAudio)

… any thoughts on the “buzzm, clickm” character?

“Hero of our nation” is part of the theme song

Another Hint?

I find it hard to believe that no one has heard of this hero of our nation – maybe you haven’t stay turned to this station?.

Anyone for a hint?

It was a cartoon that had 120 episodes that were all fairly short. That said, it could be my fault ‘memory as a child’ that is supplying the buzzm, clickm dialog – anyway, that is what everyone who impersonated this character use to say

(Edited by Ruff_Hi on 20-Oct-05 06:04. Added “Although …”)

Leif – Bingo! Well done. Although, that is still not 100% correct but I know what you mean … the missing item has to do with the definition of current time

Jezza – that was another puzzle of mine wasn’t it – I must remember that you store all these things up for later use.

Yes, I took you answer to mean noon – wasn’t there a huge government investigation into this (noon=12pm) at one stage? but it still only solves half the puzzle.

That is half correct – you are missing an important step. Also, is 12am noon or midnight?

Beautiful! – Thx Hans.

Thanks Hans – would dynamic range names be causing the second issue too? If I don’t go dynamic, then I suppose that I would have to go the comobox.clear then comobox.additem route – correct?

Further to the above post – the firing of the macro is one issue that I am running into. Another is that my drop down box is showing the wrong number of enteries.

I’ve put together an example spreadsheet. Use the combobox at B12 to select which list to show in the combo box at B14. The values in the second (B14) combo box get updated but the number of items shown are not updated. To repeat the bug that I am running up against, select “List 2” in the first drop down box then save and close the workbook. Reopen the workbook and select “List 4” then try to select “West” from the second combo box (I only see the first two enteries as the number of enteries shown is stuck on 2).

Did I say “pains” – I mean panes. One second thought, given the result, maybe PAINS was correct

I might be that one workstation has windows / freeze pains on. Or something to do with headings.