Microsoft DatePicker Error

T

tara_922

Board Regular
Joined
Jul 15, 2011
Messages
127
Hiya all!

me again...

Today I'm trying to insert the datepicker linking to cell A2. it says "can't set value to null when checkbox property false" The thing is I don't want to display the check box. Also, the form is showing up over the A column just above A1 as well as in the sheet where I placed it. The date will only change with the control that is over the A column. HELP!

Thanks,
Tara
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Sort by date Sort by votes
I'm gonna reply to myself in case somebody else comes across this problem. What it ended up being was I had recorded a macro and once that was deleted the error message disappeared.

Tara
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question Question
link a VBA checkbox to a Cell to change value
Replies
6
Views
621
NoSparks
N
H
  • Solved
VBA to change color of Forms Control Button
Replies
6
Views
1K
skillilea
S
P
  • Question Question
TypeScript (or other solutions) for modifying given list of cells (and similar problems)
Replies
0
Views
231
Pingaware
P
P
  • Question Question
Excel/365 VBA crash issues recently
Replies
0
Views
505
picklefactory
P
P
  • Question Question
putting a snippet of code from one to another somehow
Replies
5
Views
308
Patriot2879
P

Forum statistics

Threads
1,224,507
Messages
6,179,176
Members
452,893
Latest member
denay

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top