Userform - checkbox & texbox value in range

Hi HaHoBe,

thanks for your response.

I have attached now another sample, this one is almost finished, I hope you'll get a real picture now.

I merged cells only because original workbook looked very ugly, so I've done a little makeup to It.

Yes, I have noticed that mistake in x1up, but I think that is not issue, I guess It wouldn't even work. Probably the correct solution for my Userfom is Looping through columns in a specified range, but I've done like 1000 things in VBA and nothing correct. I've done some programming in VB 6 which I think is a little bit more of "helpful" in terms of programming, because or error interpreter, at least for me It was.

You'll notice that I have another macro for creating months of year - the year you put in A1 will be created with button next to It. If you have a little more time, please check that out too and see If everything is ok. It should generate sheets for months, and delete all cells as In code. Code works as I want, the only problem is that days are generated within range of first sheet as I copy It and rename It, so 31 days are copied into every new sheet, which is wrong, all months don't have same number of days. I tried deleting columns, but cannot perform that only on the columns where are redundant days, because I have needed columns after that.

Anyway, thanks for all your help, if there is anything I can do for you, please tell

Attached worksheet is not quite finished as I changed It a lot, but this file has most corrections on it, I hope It works !

Thanks a lot HaHoBe, you're The man, danke Deutchland !

Great about blanks in column B, I was actually planning to do that. I will still make some changes in code for both macros, but only few minor things.

And special thanks for:

Please Login or Register  to view this content.

....You brightened my narrow thinking with that, It solved my other problems