UserForm help

**messiah166** · 05-09-2011, 09:22 PM

im very new to user forms and am not sure if this is possible, but this is my aim.

this is what I have so far:

Please Login or Register  to view this content.

this works fine. I now want to add another txt box, and the input is entered into a calendar (psuedo calander) its just cells a-m (jan-dec) and 1-33 for the day.

so say then enter the date 5/72011 their code gets put in that cell

date:5/7/2011
reason: sick
points:5
code: AC (this is the portion i want to show on the psuedo calendar)

the file is attached. thanks much

**royUK** · 05-10-2011, 03:19 AM

Why use code to prevent using the userforms X? It's unnecessary because your close button only closes the form, there's nothing else essential performed when the form closes.

Use Comboboxes to eliminate user input error & to make the code easier

**antoka05** · 05-10-2011, 03:43 AM

I modified your macro but royUK's suggestion is the ideal.

Regards,
Antonio

**royUK** · 05-10-2011, 05:26 AM

Done a little more with a ListBox for the points calculation

**messiah166** · 05-10-2011, 12:04 PM

Thank you guys for your help its very much appreciated. Now I get to tear it down and do it for the rest of the buttons :p.

**messiah166** · 05-10-2011, 12:28 PM

actually. The reason on the attendance side needs to be user inputed not selected. Reason is it will be using the specific excuse of whomever it is and needs to be less generic. So where it says A-Absent, that needs to be as it was. But I DO need that A showing up on the calendar. This code is so much different than my humble beginnings Im not sure how to change it. And also. How do I add to the list box choices for reasons?

**messiah166** · 05-10-2011, 01:00 PM

Actually ive added the new things to the sheet that needs to be calc'd so here is the new one.

**royUK** · 05-11-2011, 02:27 AM

What other buttons?

The ListBox is populated from the Named Range
[code[ .lbxPoints.List = Range("points").Value[/code]. The Range would need adjusting to include more options.

The reasons on your attendance side is taken from the key on the page, surely if different inputs are allowed then the key is useless.

There's no clue at all as to what you want to add with the other buttons such as Vacation Balance. Whatever the basic code would be very similar

**messiah166** · 05-11-2011, 12:57 PM

There are 4 such buttons. 3 right under the first. To subtract vacation, fmla, and floater hours. I did figure it out though and have went on to create the final 3. Sometime today I will reup the file for you to look at and critique. As for the reasons, from a code stand point, and for the calendar, they are fine, but to generic to be entered into the reason box. If I call in sick tomorrow, they want to be able to type in there he called in sick. Not just that I was absent on that day. If that makes sense. But I did figure that out too. I just had to remove the line of code that had it going there and add another txtbox and have that go there. Its perfect.

Thank you so very much.

**messiah166** · 05-11-2011, 07:13 PM

here is the updated sheet

UserForm help

LinkBack

Thread Tools

Rate This Thread

Display

UserForm help

Re: UserForm help

Re: UserForm help

Re: UserForm help

Re: UserForm help

Re: UserForm help

Re: UserForm help

Re: UserForm help

Re: UserForm help

Re: UserForm help

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions