CheckBox and Submit Button

**jenniferkognan** · 06-14-2008, 01:14 PM

Hello,
i'm trying to create a macro in which there are checkboxes and there is a submit button.
each checkbox corresponds with each month's expenses
so i will have a total of 12 checkboxes and one "submit button"
i want to make a macro that will give me an option to select which month's expenses to view. all the expenses are on one sheet and how the checkbox should work is very simple. it will hide the unwanted columns to view the desired months. simple but the coding isn't. the months will be viewed until after the sumbit buttons is pressed

thank you for all your help
i would greatly appreciated if someone could help me out
thanks in advance again

**royUK** · 06-14-2008, 01:27 PM

You really need a UserForm to do this. Can you attach an example workbook so that I can see your layout?

**jenniferkognan** · 06-14-2008, 01:49 PM

well basically what i have is 1 sheet with all the month's expenses

for january it is columns A through C
february it is D through F
and so on....

if i select january checkbox, i want to hide february columns and also is it possible to have multiple selections? for example to view february and march only?
thanks for your help and also what is Userform?

**royUK** · 06-14-2008, 02:04 PM

I'll see what i can do. Food time at the moment so check back later

**jenniferkognan** · 06-14-2008, 02:23 PM

thank you
please help

**jenniferkognan** · 06-14-2008, 02:58 PM

Hello Again

i want to make checkboxes with a submit button

all my months expenses are on one sheet
each checkbox corresponds with each month
want to be able to select multiple checkboxes at once
basically how it should work is that it should only hide columns that are not wanted at that time

thanks again for all your help

Jenn

**jenniferkognan** · 06-16-2008, 09:59 AM

Okay RoyUK, i have attached the workbook and also Leith Ross's workbook

Leith's layout is what i want, Thank you for helping out

please read instructions in the workbook.

**jenniferkognan** · 06-16-2008, 10:43 AM

Please someone help me
Thanks So Much in advance...

**Leith Ross** · 06-16-2008, 11:27 AM

Hello jenniferkognan,

I made the changes you requested to the attached workbook. Each month now uses 4 columns per month. The totals in the 4 column of row 52 for month are totaled together as before. The user form can be launched by typing CTRL+R from any worksheet or by typing ALT+L when the worksheet with the button is active.

Sincerely,
Leith Ross

**jenniferkognan** · 06-16-2008, 11:31 AM

Hello Leith Ross

Thank you for the new worksheet but i had some other things to do

Hello,
it's me again

Also what i was looking for, i think this would be impossible, but rather let me give it a shot

there's a a "paid to" with "type of payment" (for example, credit card, check etc..)column, standard "number" column (lists all the bills like 1, 2, 3, in numerical order), and finally there's a "amount" column. is it possible to have them organized when you make the selection.
each month has four columns so i think you would have to edit the code

and on the window that pops up, is there anyway you can add a check box selection, like an option that says "okay for that particular month (s), organize it by "amount" (ascending) , it is already in alphabetical order, when the user inputs the data in the column it is alphabetical order...

so each month has four columns

jan - A B C D

feb - E F G H

and so on.....

Thanks so muchh............

Also i want to have an option to organize it by the type of payment also
so a total of two options....
the user can only select one of them....

and when you select an option, the corresponding "paid to" individual or "amount" should be the same meaning
if the user selects to organize by amount, the "paid to" should correspond to the amount, it should be like grouped together so that when organizing it, it really doesnt' mess up the data....

**jenniferkognan** · 06-16-2008, 12:04 PM

Hello Everyone....
I'm very new to VBA

can anyone help with the above problem?
i have attached the sample(book 1) and the file that is the most closes to what i like (example 2 rev 2)

Thanks Again

**Leith Ross** · 06-16-2008, 12:05 PM

Hello jenniferkognan,

I am closing this post because your requests are straying to far from the original topic. It also appears to me that you need help creating more than a simple interface for this project. You should stop and think about what you need and create a list. Submit this list under a new thread. Both Roy and I have to attend to other members' requests for help. Perhaps you should place a request for help in the Commercial Services forum.

Sincerely,
Leith Ross

CheckBox and Submit Button

LinkBack

Thread Tools

Display

Hybrid View

CheckBox and Submit Button

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions