Word 2007 DropDownList Number?

ssmacc · 14 Oct 2010 at 13:38

Hello,

I'm trying to create a form with a drop down list with numbers in it, I’ve done one with dates and text, but I’d like a list of numbers to pick from, anyone know how to do this?

Cheers

A[L]C · 14 Oct 2010 at 14:59

data validation -> allow whole number

ssmacc · 14 Oct 2010 at 15:33

A[L]C;17572800 said:
data validation -> allow whole number

Sorry where is 'data validation' in word?

Thanks

A[L]C · 14 Oct 2010 at 15:36

Ahh sorry assumed excel.

Enable the developer bar in options.

Add a drop down list

Highlight it and click properties on the tool bar.

At the bottom add in each of the numbers you want to be able to select

ssmacc · 14 Oct 2010 at 15:50

Yep I’ve seen that way of doing it, the problem is the number could be anywhere between 1 and 1000, I was hoping I could have a similar grid(?) as you have with the pick a date dropdown.

Thanks anyway

A[L]C · 14 Oct 2010 at 15:58

Depending upon the document being produced it MIGHT be easier to do this in Excel, in that Excel has direct support for data validation, which can be set without programming to have one list dependant upon another selection. In word, you will need to use VBA, and this would be dependant upon the type of drop down menu you are referring to (combo box presumably, but from which toolbar?)