Date picker cell

[donkey_uk]

HI Can anyone help

I have a workbook with a date picker in a few cells with code, all works perfect, however when I click on the cell I can input any data and when I click out of the cell it errors out.

if I click on the data picker dates its all ok.

What I would like to do is lock the cell so only a date from the date picker will be shown, or even a msb box saying input error please input correct date


Can anyone help me on theis. Here is the code that im using

Please Login or Register  to view this content.

[kev_]

One trick I have employed to prevent the user being able to edit the cell directly:
- insert an active-x Label
- position it over the cell
- make it the same size as the cell
- make it transparent
- make it move and resize with the cell

Then to amend the cell value
- attach a click event macro to the Label which triggers your date picker

[kev_]

Here is a carrot for donkey

Attached is simple example of blocking direct edit of a cell
- the cell is named Cell_1 using a named range
- avoids risk of rows or columns being inserted and changing the cell reference
- a message pops up when user clicks on cell
(in fact user is clicking on transparent label)
- the event macro moves\sizes the label in line with the cell
(I would not necessarily trigger it by every SelectionChange event - but the code is useful and the label must move when rows are inserted etc)

The protected cell in the attached workbook is cell D2

Please Login or Register  to view this content.