Results 1 to 3 of 3

Thread: Setting date picker to certain columns only

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Contributor
    Joined
    Jul 2011
    Location
    Manchester
    Posts
    142
    Location

    Setting date picker to certain columns only

    I use a date picker on most of my workbooks so users enterthe date in a correct format but at the moment it works by double clicking onany cell on a work sheet.

    Can anyone show me how to restrict this to ranges in certaincolumns on please?
    In the attached example it would be A2:A100 and D2100 only

    Thanks as always
    Mykal
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •