If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Data Validation Text Box

Thread starter Guest
Start date Mar 7, 2002

Guest

Mar 7, 2002

Hi: I have created a spreadsheet with most cells having Data Validation in them. I have mainly used the Data Validation for general comments (eg. Type persons name here). My question is in regards to the location of the Data Validation Text Box. When I orginally do the Validation the text box appears underneath and to the right of the active cell. This is what I want. The problem is that if someone clicks on and drags that box it no longer appears in that location it now appaears whereever they have dragged the box to as do ALL OTHER Data Validation Text Boxs. This spreadsheet will be iused by a lot of people and I am sure someone will move the Text Box. Does anyone know how I can make sure that the Text Box ALWAYS appears below the active cell. Any help you can provide would be greatly appreciated. Thanks