Problem With Date Picker

  • Thread starter Thread starter CoolCyber
  • Start date Start date
C

CoolCyber

Hi,
I have used Microsoft DatePicker control in a spreadsheet. But everytime i
open the sheet, the date picker is disfigured. It elongates vertically and
reduces in size vertically. But if i scroll to make it not visible and
scroll back it displays correctly. I have tried giving its location, width
etc when workbook loads, but its of n ow use. Any Ideas on how to make it
display properly.

Prn
 
If scrolling seems to work then it's probably a graphics problem. Maybe
Excel isn't redrawing the screen properly until you scroll up and down.

You could try writing a macro that automatically scrolls the sheet when
you open it then scrolls back
 
Just a thought...could it be anything to do with frozen panes. This does
strange things to comments for sure

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
Thanks for the reply. Well thats what im doing right now, scrolling up &
down using a macro. But am not sure if it would work for all. so was looking
for a better solution.

Prn
 
I do not have any frozen panes.

Nick Hodge said:
Just a thought...could it be anything to do with frozen panes. This does
strange things to comments for sure

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error with Date Picker 3
Range names shows up in cells 1
problem in date time picker size 3
date picker problem. 4
Date Picker with Inputmask 3
Date Picker 11
Date Picker component 1
Excel Date Setting 1

Back
Top