Same kind of option - Multiple entries - scrolling

Hi,

I have a table type - multiple entries in user form. Is it possible of bringing the same kind of option has attached jpeg

Please Help!!!

Attached the file for your reference

Hey there,

Can you provide an example of your workbook instead of just s screenshot? Also, give me some more information?

Thanks!

Hi rvasquez,

Attached the excel file.

Pls Click the Stock Entry Button. Form loaded with Add Material option. Default it is four rows. But when there is more items to be entered, how can add more rows of cells. form gets bigger if i add 10 rows by default, so im trying to get scrolling option.
Also please check sheet 'Stock Entry' and this is how i need to get data/items below each date/entry

Pls Guide.

You should just be able to Select the control entitled Frame1 (Add Material) on the Stock Register form. Then in the Properties Window scroll down until you see Scroll Bars. Select the vertical option here.
The set the Scroll Height property to something like 255. This will allow you to have a scroll bar.

Dear rvasquez

Can you please help me in making this form working. I tried learning/implement this vba coding, but i cant get it done.(Sorry)
I have sample data in the Worksheet (Stock Entry)

Please...

Thank you!

sk

I can but I'll need a little more information also I have a project at work that is going to take some time so it may take awhile to get back to you sorry.

Please take your time. Your help is much appreciated.
Thanks for your kindness

Okay take a look at this

Oh! yes. thats what exactly i needed.Thank you.
And thanks for your reply.

Great! Don't forget to mark this solved and maybe give me a little star tap Thanks!

Sorry, I didn't see that last post. Usually if you tell me thanks and that's exactly what you needed, I will unsubscribe from the thread as my subscriptions tend to become a lot as I help people. How would you like search for the records to edit?

Search for the Records is doing great. Only the last record is not showing until I re-change/select to same month once again.
Eg. If Selected "Apr" month and entered all the data then clicked submit the data is stored, but when i click the record tab it is not showing the entered data, so i have go back to the main entry form again reselect the month (first select "may" then again "Apr") then the data is showing in the record tab.
Thats the only issue im facing with search, otherwise all is fine and great.

Are you talking about the previous form I help you with for search? I'm confused please specify which forms you are talking about thanks.

Yes, I am talking about the previous form only. This thread also has same functions. So Im also confused about your question below

rvasquez : How would you like search for the records to edit?
So I took a chance of explaining the previous form issue

But Really need your help on this new thread to get this form into action

Thanks

Hello there,

For future reference it would be nice for you to specify which threads or files you are talking about and maybe provide a link to them so that others who may have had the same question with that thread can see the answer.

In regards to the thread "Data Entry Form Help!!!" file "DataEntryForm(1).xlsm‎"
(thread: http://www.excelforum.com/excel-gene...html?p=2811615)
To have the last record update without having to reselect the month follow the below steps:

1. Open Visual Basic (Alt+F11)
2. Double click on the UserForm1 in the Project Explorer Window
3. Right click on the Search Button on the tab Input Information on Userform1 and select View Code.
4. Under the code

Please Login or Register  to view this content.

Add the following

Please Login or Register  to view this content.

5. Then scroll down throught the code until you reach the lines

Please Login or Register  to view this content.

Insert the following lines of code BEFORE the End Sub

Please Login or Register  to view this content.

6. Exit out of VBA and test the form.


For the Thread entitled "Same kind of option - Multiple entries - scrolling" file "StockRef1(1)
(this thread)

I have been working on how to add the entries from the userform "Stock Register" into your workbook for you. I have figured this out but I assumed when you asked me to help you with the search that you were talking about this form.

So you have designed your form so that there is a Record tab where there is a listbox I'm assuming to pull records in. Then you have an edit and save button which I'm assuming you want to be able to populate the Stock Inward Entry tab with the information selected on the Record tab listbox (life your form from the previous thread).

Now, maybe my question I asked about will make sense.

How would you like to search for the Record to edit?

Just let me know.

Thanks!

RVASQUEZ

Hi RVASQUEZ

Thank you so much for your detailed help.

1. SOLVED, that was very easy with your help: To have the last record update without having to reselect the month.

2. Sorry . Now i got your question. Date And Month Wise (Search Record to Edit)

Hey there,

Sorry it took so long. This was quite a thoughtful task for me as I had to consider all possible outcomes and problems that might arise. Attached is your original workbook updated to do the following:

1. Append new records from StockRegForm to StockInward worksheet
   • In 2nd empty cell in column A after the last row of the last record there will be the text End Sub
   • DO NOT delete the work End
   • It is used to edit the last record on the worksheet.
   • If you delete this then when you try to edit the last record the code will throw an erorr because it is unable to find a value after the last record. When you read the code for the Edit button this will make a little more sense.
2. Search for Records
   • To search for a record you must enter it as a whole date such as 06/18/2012
   • The date will automatically format when pushed through the code so you can enter it as 06/02/12, 06/02/2012, 6/2/2012, any of these will work as long as it is a whole date.
3. Edit an existing record
   • You can make changes and also add materials.

I hope that my comments are sufficient enough but if they are not please feel free to ask any questions.

Thanks,

RVASQUEZ

Hi RVASQUEZ

THANK YOU VERY MUCH for your EFFORT and TIME. Best Contributor ever seen.

Query's
1. Tried editing record using format 06/18/2012 - Error : Invalid procedure call or argument
2. Inward Material Details - Added new Item (in Sheet RawMaterialList) but the related sizes in not showing in the Size column.
More Items and related sizes may be added frequently

Thank you

Hello there,

What do you mean by you tried editing record using format 06/18/2012? If you mean you tried to search for I entered it in and it worked. So if you could tell me what you meant and then also what line was highlighted when you click Debug that would be great.

For the Size value - the sizes in the drop down are pulled from the RawMaterialsList worksheet as you requested. If you would like different values to be pulled then you would need to add them to the RawMaterialsList worksheet in the correct row.

Hi,

For some reason these two options is not working for me

1. Search > 06/18/2012, Error line: Application.Go to FndC
2. Added new item in RawMaterialList worksheet in row A8 (Item name) B8 (Size), I can see only new item name in form but not related size.

Thanks!
SK

Could you please reattach the workbook for me with the things you have added or attempted so I can try and work with it? Mine seems to be doing okay so maybe something didn't transfer over, it'd be easier to just work from the one you are looking at. Again, please add the information you were trying to add to the Raw Material worksheet.

Thanks!

Hi RVASQUEZ

Attached with some entry.Please have a look

Thanks!

Okay I fixed the problem with the size but was unable to recreate the problem with the search. Could you explain step by step what you are doing to create this error?

Thanks!

Ok.

Search

1. On Stock Inward Entry Form > Clicked on Record(tab)
2. Under Date(mm/dd/yyyy) Text Box, I entered "08/06/2012" and then clicked the search button next to that.
3. Error: Invalid Procedure or call argument > Debug > Code opens at line : "Application.Goto FndC" (yellow highlighted)

Size : (added new items and related sizes in RawMaterialList Sheet)

1. On Stock Inward Entry Form > Frame :Inward Material Details, Under Item drop down box > Selected "NewItem1" > next Size dropdown box > I found Empty
2. Then If i clicked button "Add another item", a new set of column appears in 2nd row. > Selected "NewItem1" > next Size dropdown box > Values found.

I am using Office 2003

Thanks!

Okay give this a try. I uploaded it as a 2003 document as well let me know if this affects anything.

Thank you!

1. Item and Size works

2. Search : Data found successfully. But in the date column Item name is pulled / misplaced and some of the other items is also misplaced while editing.

3. Please help me out in Validating Only one field rest i will follow the same coding. Eg. Date is required field

Thank you so much !

Hello,

I'm not quite sure what you mean by it is pulling in information into the wrong spots as mine is working completely fine. Unfortunately I cannot try and recreate your problem so if possible, you'll need to look into the code yourself and see if anything is associated with the wrong column or control on the userform.

As for validating certain cells you would use a line of code like below:

Please Login or Register  to view this content.

You can see an example of how to do this on your other workbook UserForm(1).xls I helped you with under the SubmitButton_Click Event.

Here is a link to your previous form

http://www.excelforum.com/excel-gene...html?p=2811615