#1
|
|||
|
|||
Conditionnal userform possible?
Hi,
Do you think it would be possible to have a conditionnal userform, depending on data entered by the user? Here's what I want to do: The user enter a letter assigned to an area and a then a number which correspond to the number of objects found in this area. So user enters letter A and number 15, then a second userform opens whith 15 rows marked A1, A2, A3,... to A15 and the user just have to enter the description for each object. Then of course all these data will be stored in the worksheet and the userform reset for area B or C.... I'm not asking here for someone to write the code for me or anything like that. I just want to know if it's possible and maybe a tip or two ;-) Thanks |
#2
|
|||
|
|||
Sounds like you are unnecessarily complicating the process for the user.
What is the purpose of this project ? Completing an invoice ... entering inventory received ... tracking items ? Provide additional information of the overall goal and perhaps a more effective solution can be presented. |
#3
|
|||
|
|||
The purpose is to make an inventory of objects found in different rooms or areas.
And if possible, the user wont have to enter every "reference" of each object (A1,A2,...) |
#4
|
|||
|
|||
Ok ... your goal is a little clearer now.
What happens if the user starts with 15 rows but after entering a few items, they discover the need for 17 rows ... or the actually only needed 12 rows ? In either situation the user is already restricted to 15 rows. Do they delete everything they have already entered and start over ? Why the specific need to restrict the user from the beginning to X number of rows ? |
#5
|
|||
|
|||
Here is a suggested method : (attached)
|
#6
|
|||
|
|||
I don't really need to restrict the user to a fixed number of rows but I'd like the reference (A1,A2,...) to be written automatically so the user just have to enter the description.
Thanks for your userform, the idea is good, I'll work to add the reference automatically ;-) |
#7
|
|||
|
|||
Best wishes.
|
#8
|
|||
|
|||
It's possible, whether it's worth it or not is debatable.
I think the very simplest way to deal with this would be using Excel's built-in data form. It's very simplistic and you can use it straight away and it requires no programming. Being a glutton for punishment though, I had to have a kick at the cat with a User form. This puts two hundred text boxes into a scroll-able frame on the user form and who knows what would be required from there, more work than I'd want to do. Good luck with your project. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Userform calls other userform, then populate worksheet | Lehoi | Excel Programming | 0 | 02-03-2016 02:58 PM |
Keep Userform on Top | didjee | PowerPoint | 5 | 10-20-2014 02:22 PM |
VBA Code in a UserForm module to delete a Command Button which opens the userform | Simoninparis | Word VBA | 2 | 09-21-2014 03:50 AM |
Is it possible to take an input from a UserForm in one document to a UserForm in a do | BoringDavid | Word VBA | 5 | 05-09-2014 09:08 AM |
Conditionnal copy/paste | Michael007 | Word VBA | 3 | 12-14-2011 09:28 PM |