Userform possibility question

[benfinn]

I want to write a VBA excel code that will allow the user to double click on a line and have a userform pop up. The user for will customize itself based on the information in that line. It will see I clicked on line 7 and it will add the label for line 7. The problem is that I need it to go deeper. I want to use the userform to adjust some numbers at a more granular level than the line that they clicked on is. The form will have to take corresponding information and add a variable number of labels and text boxes and spinboxes (up to 20). Each line will be different. My question is: Is it possible to add a variable number of labels, text boxes and spin boxes and position them at run time?

[MarvinP]

Hi benfinn,

Most things are possible with VBA with enough study and effort. In your case, I'd put all labels and text boxes and controls on your userform and then either make them visible or not based on the row you double click on.

Hope this makes your problem easier.

[royUK]

Vague question, the answer would be yes.

[benfinn]

Sorry for being too vague RoyUK.

MarvinP - Thank you so much that does make my life easier. The aesthetics might be off a bit since I will need to make so many invisible (There might be large empty spaces to account for the hidden labels and boxes) but it should be an easier solution to someone of my skillset.

Do you think you could give me a small example code of how to alter the properties of the userform at runtime? I'll run a loop to count the number of labels needed to be unhid but I dont know too well how to alter userforms and I am having trouble finding example code.

[royUK]

You still aren't giving enough information for what you want, what determines the number of rows & labels required? What do you mean by granukar?

If you explain the problem properly there is probably a simpler solution

[benfinn]

I have a budget application: The user inputs workers, the workers levels (level 1, 2, 3,4). costs, and periods (period A, B, C, D) then it opens a new worksheet showing summaries. One of the summaries I work with is by period by worker level. This shows the percent of each worker level being used for each period (i.e. period A has worker level 1 working 50% of the time and 2 working 25% and 3 working 25%; since worker level 1 costs more you might want him working less and worker 3 working more.) I want to make the application more dynamic.

What I want to do is to allow the user to change the percent worked from the summary worksheet. However since there might be three workers at level 1 and you cant just adjust their time across the board i need to go down to a more granular level.

This is what I have so far:
I will use a double click event to open a userform. It will search the selected field for the row and find all the corresponding data to populate the userform. Then it will search the first worksheet to count the number of workers at each level using a loop. Originally I wanted to use this number to add additional labels and spin boxes however the idea of making them visible has some promise. My problem is This is my first time working with VBA excel userforms and I need some advice. If possible could someone show me how to alter the properties of userform at runtime?

RoyUK - Does this clear up everything?