how can add value in specific cell using userform VBA

[mazan2010]

Dear All expert
marry Christmas for all and happy new year

i would like to know if the date picker can add in excel 64 bit becuase i try to add in microsoft control but still missing in
list and found someone wrtie on internet its only work on excel32 its correct?
if correct , how can replace date picker in excel 64 bit?

second i would like to use userform to add value to excel sheet as in my attahced file
want to add value in B column With yellow color using userfrom
then when i press calculate and export button first check if there is any value not enter in textbox or not and if any one missing
show me the missing in pop message and goto with scrol mouse direct to missing or show all missing with other color (red)
then if all completed want to export data in report sheet in range A1 : D49 only in one page with gridline (pdf file) with
the same formate of excel sheet
and show me windows that give me choice to save the pdf exported file on any directory i select



pdf file exported want to be secured meaning protected from editing
thanks for all attention and concern
regards

[humdingaling]

for part 1
untested myself but seems you can just bring it in manually
https://social.msdn.microsoft.com/Fo...forum=exceldev

alternatively just use a custom one
http://www.rondebruin.nl/win/addins/datepicker.htm

[mazan2010]

Dear Humdingaling
many thanks for your reply
i try two methods but it not working
first one
untested myself but seems you can just bring it in manually
https://social.msdn.microsoft.com/Fo...forum=exceldev
its write work on excel 32 bit with windows 64 but my case excel 64 on windows 64
second one its work but with sheet not user form meaning if you look to my attached file
first items is Date want to enter date in this easily with other data then press command button to enter value in corresponding cell in specific sheet
hope you can understand me

[mazan2010]

here the last edit in my file that i found code online and its work for data entry but how can make other

[mazan2010]

can someone expert check my last file i try to add another code for exportation that will open save dialog only with PDF option but want to this code with add data entry code only one button not like my file two
also file name will be from cell B3 in report file

[Logit]

.

Here is some of the code.

Please Login or Register  to view this content.

[humdingaling]

whoops
did my example but forgot to post it

see attached working for the color textbox and checking to make sure all text boxes are fill in because writing output
did some minor tweaking of the control names (mainly the labels) to facilitate

Please Login or Register  to view this content.

[mazan2010]

whoops
did my example but forgot to post it

see attached working for the color textbox and checking to make sure all text boxes are fill in because writing output
did some minor tweaking of the control names (mainly the labels) to facilitate

Please Login or Register  to view this content.

Dear humdingaling
googd morning
your post its working in data entry and for missed data but it give error debug message even i make ok to enter missed data as in attahced photo

[mazan2010]

Dear Logit
good morning
your post its working also good for data entry but for exportation its give me message the data save on my location but when i look to this location nothing found

[humdingaling]

What line is highlighted when you press debug

[Logit]

.
My apologies. Left off a line or two. Here is the corrected macro :

Please Login or Register  to view this content.

[mazan2010]

What line is highlighted when you press debug

Dear humdingaling
I try it again and it working now after i save it on my computer not like before open it direct from interne

[mazan2010]

.
My apologies. Left off a line or two. Here is the corrected macro :

Please Login or Register  to view this content.

Dear Logit
its working now but there is something missed
first not make highlight for missed value , just give error message
second file exportation need to be name of value in report sheet cell B3

[mazan2010]

Could you please change the code to fit export data not from active sheet but from specific sheet Named (Report sheet)
and file exported name from B3 in report sheet
and all data fitted in one page and file exported have the same format as in excel even grid line