How to transfer the String from Checkbox

A Sample file will help to read the code while 'in action' Instead of Current Region I would use the rows.count).End(xlup).Row but that is a choice

You should read the forum's instructions

Here is a small doc explaining it.

Firs, why is your file so large?
Because you have saved over 1 million rows of 'empty' rows.
The file is only 29 KB and NOT 5 MB !!!
Okay, I rand a test without knowing what it is supposed to do.
but lets see if I understand the user form you enter a report name, the two persons whatever start time and then check all the checkboxes.
What does you end result look like?

I have reattached the file with my result so if you could fill in what you expect to see too then it will be easier to understand.
I checked all the checkboxes in the first frame but not all showed, so please explain and show the result (fill it in manually) to see if then we can help.
What needs to be saved in the 'database' worksheet?

The code you have here does not make sense.
You can choose many checkboxes but you only save 4.
For every row?
Please Explain it clear and Give me a sample of the result you what. your words do tell this to me and I am sure you can explain it better.

I attach the file again with a screen shot and the vba has been modified, but still tell me more please, if you want to be helped.
If English is a problem try it in French

My msitake, change the foloowing line of code back to this

Please Login or Register  to view this content.

Just one question, why did you clear a cell value if the checkbox was not selected?
That is where to test If me.Check... etc Then value Esle ""?

Does this mean that now you are going to add all the other IF Checkbox? = True Then ... for ALL the checkboxes? What happens if you decide to add an extra checkbox, that will all need to be rewritten again!
This is not the way to do that and as I see it you fill the CheckBox's caption as information, True?

You should use Control to loop through all the checkboxes

This one will process any checkbox you select in any of the multi pages

How wre the points (scores) counted what determines the value? You posted that too and also the time difference.

The time difference are now ok. The Textbox5 has default 100% on it. then once the Checkboxes checked by the user the corresponding score will be deducted to 100%. Thank you for patiently helping me

Unable to remove Footer 1.00%
Unable to use PMSectionHead as First Level header/section 3.00%
Unable to use PMSectionHeadLevel2 as Second Level header/section 2.50%
Unable to use PMSectionHeadLevel3 as Third Level header/section 2.50%
Unable to use QuestionStyle_HangingIndent (questions with a number/letter prefix) 2.50%
Unable to use QuestionStyle_NoHangingInd (questions without a prefix) 2.50%
Unable to use QuestionStyleBullet (questions with a bullet prefix) 2.50%
Unable to use QuestionStyle_Alpha (sub-questions with a number or letter prefix) 2.50%
Unable to remove Extra spacing 0.50%
Other 0.50%

But, what is the corresponding score for each checkbox? and what are the number of questions used for?
I made s minor modification.
I noticed that there is always an option 'Other' but when you read the file you do not know which checkbox page was clicked for the 'Other'

I highlighted the resulting selection

Looks all good but then I would appreciate you attach the correct file with all the pages. The one you have been attaching stops with File name:

I hope you do not mind, I've been playing a little with your file and added some minor features such as showing the score.
I find it very un-maintainable that you would have to add an event for every checkbox changed.
I also place the named ranges so you can just add reviewers and requesters (Sheet3) and not have to modify the vba code to refresh the comboboxes. The named ranges are dynamic.

Oh, and there is a macro in the XtraModule01 named MakeCheckBoxList()

If you add checkboxes to the userform, all you have to do afterwards is run that macro and the list of checkboxes in Sheet3 will be updated with the new ones and all you have to do is add the score value in column B for it to work

And, the userform is opened by Right-Clicking the mouse in Cell A1 of the Database worksheet

Have fun with it

The file now opens with the Database sheet as active sheet.
All you need to do is right-click Cell A1 to open the userform
I mentioned that if the post.
However if you want a button, just place a button or shape anywhere you want and assign the macro in the mdoule to it: showPrepForm() this macro is in the XtraModule

Yup I already created a button to show the userform, is there anyway once I click the show userform button the sheet will switch to database?
And also it is possible if the Database sheet was on a different location(shared drive) so we can have a centralized database sheet.

Thank you

Well if you have the macro that is assigned to the button.
Think of VBA like a book you are reading, every line you read is an instruction to be carried out.
So try it...
What is the first action you want to do?

In this case just two actions.

1. Select / activate the desired sheet
2. Show the Userform

You go the second one right or else the userform will not show.

So what would be the first step? ......

If you can't figure it out, the answer is way down

Please Login or Register  to view this content.

The database is sheet is where you open the Excel file.
I think you are talking about a shared file.
That is a little more complicated to do and my experience with shared files is not that good.
I would suggest you create a copy of this file and place it on the share then look up the settings and set it to be used as a shared file, but like I said, I never used this but you can try.

Then you remove that in the VBA code, like I said before, read VBA like you would a series of instructions one after another respecting the VBA syntax

The RED text is what you have

Please Login or Register  to view this content.

The GREEN text is what you want

Please Login or Register  to view this content.

You can always leave the vbCrLf but why do you want the empty line?

Messages crossed
You see, it is not that difficult, it just requires patience AND time

You will have to add an object to the userform and code that:

This link shows only the table portion but you could edit it.
http://stackoverflow.com/questions/1...el-on-vba-form

It is not for me to judge but I am just curious why you would want to do that anyway.

Why not just add another form to search an look?

Using the link I sent you you could add a userform that shows only the group of rows you want to see.

Good luck.

If you have something that works or the basic idea maybe I can take a look too.

I've got the ideas but not the code and not the time to write this, and more, you should do it as much of it yourself to understand the basics so that you are not dependent of others.

I do this normally for a living. (www.hcandts.com)

When you have the time, write down what you want to achieve, scrolling down with the userform on screen will hide much of the screen since it's quite a large userfrom and also depends on the screen size.
I have a 22"and it fills it nicely with not much space to spare.

I'll look at it later today, this afternoon is a little busy.
One other question though, the scrolling of the database 'records' is this merely to see the results? Or also to edit?

Looks good, and .... you want to know why it is not working?

Two things: your Multipage is named Multipage2 and not Multipage1, I changed that to be Multipage1 too.

The function GETSCORE was a PRIVATE function, this means it only works in that module.

I moved it to the XTraModule VBA and made it a Public Function. it works.

When you copy userforms or code the checkboxes an everything change.

You will have to keep in mind that if you add checkboxes but want them to work but the name is unique, the you will have to give each checkbox a name so instead op Checkbox1 or CheckBox2 to name then CheckBoxREP1 for all the Checkboes in REP and CheckBoxPRN1 for all in priter or whatever you think of.

I'm not genius and I'm learning every day. It all comes down to simple logic and filled back-pack, during the years you collect and store information, it always comes to use and at the same time you develop your own techniques and those are difficult to teach, they're based on experience, a race driver can tell you that you have to stay focused but the technique itself you can only do it on your own.

Programming is no mysterious thing it it just straight logic and with time and patience you will attain your own level of genius

One thing, you now have two userforms what when you add a third, edit Sheet2 and add a new button?
You see, it starts with these small things haw can you make something like this dynamic and and be able to modify it with the least effort, this is where time and logic comes in.
I've got an idea but will have to work it out.

If you really like programming and 'puzzles' it's great.
I started with macro's somewhere in 1995 and I've now come to develop quite extended applications and have been doing small jobs on a contract basis since my retirement.
Your boss will need to allow you time if you really go into looking deep into it.
There quite a lot of sites take a look at Ron de Bruin, Chip Pearson , Ozgrid well, there are many.
My Training Hub (Australia) is a nice site and the newsletters are revealing as are the available sample files.
The Office Ribbon is a nice one, I customize the Ribbon for my projects.

Take a look at this post and the sample file, the video just shows what it does
http://www.vbaexpress.com/forum/show...erform-Example

I was thinking that you could do all that in just one userform but the comes the point that I do not understand the scoring method
I'll put together a test version that uses both Userforms which their own checkboxes.

I have the idea and will do so but am a little busy now

I am assuming that when you run one form an the next it could be for the same RFP and same requester and reviewer, correct?
Wouldn't you want the score for each checkbox place in the score column so that you can add them on selection? and what about the number of answers where does this come back.

You could do it
If each has his own file then the option could be added to 'upload' the contents to the shared file and after that remove it form the user's file, that way after every 'Submit' the question could be asked 'Do you wish to upload / transfer results to master database'

Then the Manager only has to look at that one.

Again, you have not answered the question about the scores and if it is so that different forms can be done for the same requester/reviewer and RFP?

I am stalking you just one more time.
I managed to make my idea work.
You add your new userform and make the necessary modifications so that it works.
These are the next steps:
1. Unhide Sheet3
2. in Column J under USERFORMS add the new Userform name to the list, DO NOT insert it in between but just add it below.
The Named range is dynamic so nothing to do there.
3. In the xTraModule01 execute the macro MakeCheckBoxList() and the new form's Checkboxes will be added leaving Column B blank so you can place the new Scores here or modify any of the existing, that is why the Userforms list must not be modified since the userforms are read in that order.

4. Hide Sheet3 again.
5. Save the file

And then right-click Cell A1 and you will see the new userform in the selection form.

If you misspelled the Userform's name or it does not exist, it will not show and will not be available.

I have attached version 2.2

Hi I need some enhancement with the Tool. I will add a textbox on each form, for every Other (Combobox) checked the user need to input a comment on a textbox. I will attached the updated file. once the user submit the button it will also transfer to Additional Comment Section located at "Quality Database Sheet", or is there anyway that instead of adding "Additional Comment" section in excel the string inside the textbox for other will combine with "Other - "String inside Textbox" ? like what you did with the Combobox Parent.Caption. Please refer to Final UserForm. Thank you

You want the entered comments to be included when saving?
Is there a limit you to the amount of text?
Only those forms that have a textbox?

You want the entered comments to be included when saving? - Every time we use the Other (Checkbox) we requiring each user to input additional comment
Is there a limit you to the amount of text? - None
Only those forms that have a textbox? - Actually All Userform except Activity Tracker

Do you know the amount of code that is required to make this work in a professional way?
My first suggestion and I would appreciate it if you did that.
The TextBoxes must all be renamed.
Suggestion: if the CheckBox for the 'Other' is named CheckBox34 then name that TextBox TextBox34 that way you can reduce the overhead
Also each TextBox must have the EnterBehavior must be set to True for these textboxes.

You say "Allright! Thank you" but did you understand what I meant?
I will try my best to help you with where I can

Yes I understand and also I'm trying to figure it out. Thanks in advance.. Have a great day!

Here is the updated userform

Thanks

I'll see if I can figure it out

Don't thank me yet, I don't know if I can solve it

Hi, sorry to have kept you waiting.
I think I got it working.
Try the Final Userform. Do NOT hide the textboxes since there is no triggering for the Checkbox with the caption 'Other'

One important condition for this to work:

The CheckBoxs have a sequence numbe so evry CheckBox99 which is for the option Other the TxtOther99 should be the same number

So if you check the Userform Final you will notice I modified that

CheckBox27 the TxtOther27 corresponds if that is the caption "Other"

See the attached file and test it.

You will have to edit the other forms accordingly

Hope you can work it out from there.

You had made some mistakes in the code

I added a control to force the comment too

I named the file V3.4 and 4 stands for April

I got one question, what does the 'Activity Tracker' do?
I played around with your file and noticed that it is possible to do all that with one 'Multipurpose' userform so that you can add new checks without having to add a new form for every one.
See attached images, the selection form where the list shows the available forms and the multipurpose form that is populated depending on the choice

But what if you want to add another Task you want audit another Task, you now add a new form do all the checkboxes and comment textbox and then you can work.
My idea is to have one Userform that you can use for every option, even permit to select the dropdown (Comboboxes) depending on the selected task.
All you have to is complete the Captions for each CheckBox and indicate if you want the comment field visible to permit extra comments even it is not the 'Other'

I always see if I can find a way to avoid extra work when there is code that could be done with one module only and some extra settings.

Let me know if your interested.

I'm fine, this is what I have so far, when prompted to enter a pass word ... enter your username (case sensitive)

I was waiting to see if you were really interested.

I have not had the time to write a small manual, but give it a shot.

Press 'Maintenance' log in and then press Add Activity

I have not had any time to write any explanation but I did make some minor modifications which will probably make it easier to work with when adding a new activity

Like I mentioned before I did not touch "Activity Tracker" since I have no idea what you want with that.

I was wondering if you managed to test it?
I made some minor modifications and put a PowerPoint presentation together to show how it works to add a new activity and so.

Glad to hear it works.
Here is an update to make it more intuitive.

I suggest you start a new thread for this