Sort and input through spreadsheet

Hello everyone,

I am brand new at using VBA and I am having a ton of irritating issues and I would really appreciate it if I would be able to recieve some help!

I am working on a large spreadsheet with a large set of data and I need to ask the user for input and sort through the spreadsheet to see if the user's input of a number is already in the spreadhseet, if so, i need to insert a row below and as the user to input the new data for each cell.

I am not sure if that makes any sense, but this is what i have so far.

Thank you so much in advance!

Please Login or Register  to view this content.

I think your situation is the ideal candidate for a UserForm. Would make your life and the user's life a lot easier.

Originally Posted by stnkynts

I think your situation is the ideal candidate for a UserForm. Would make your life and the user's life a lot easier.

stnkynts,

I have no idea how to go about doing that, but I will try!
Thank you for putting me on the right path!

For your situation think of a UserForm as a giant input box where instead of having your code prompt you with 10 input box questions you just have 1 userform with all the questions on it. The user would then fill out the questions and the answers would be applied to the worksheet. If you get a UserForm created with all the questions you want and associated textboxes submit it and we can probably work up some code quickly for you.

Originally Posted by stnkynts

For your situation think of a UserForm as a giant input box where instead of having your code prompt you with 10 input box questions you just have 1 userform with all the questions on it. The user would then fill out the questions and the answers would be applied to the worksheet. If you get a UserForm created with all the questions you want and associated textboxes submit it and we can probably work up some code quickly for you.

stnkynts,

Thank you so much for all of your help.
This is what I came up with so far!

screenshot_userform.jpg

Here is a sample of what the whole excel spreadsheet would look like.macros_excel_sample.xlsx

Your submitted workbook does not have a userform.

Originally Posted by stnkynts

Your submitted workbook does not have a userform.

stnkynts,

Is it avialable on this one?
I have no idea why it did not show up on the previous one...
I also Wrote some code for this userform, however it keeps giving me errors and i have no idea how to fix it...
And my other issue is that i need it to input this information afte rit scans through old sets of information and sees if a submittal number is already there and if so, it inputs this new information underneath it...

Thank you!Master Submittal List Macro - Copy.xlsm

And if it is still not there... since I have no clue the reason for that,

here is the code:

Please Login or Register  to view this content.

I started working on this then realized what you said in your posts and what you have as data on your sheet makes no sense.

I am working on a large spreadsheet with a large set of data and I need to ask the user for input and sort through the spreadsheet to see if the user's input of a number is already in the spreadhseet, if so, i need to insert a row below and as the user to input the new data for each cell.

"User's input of a number" - What input is this? Do you mean the CDRL ID #? If so your supplied data has only 3 numbers in an odd orientation with different formatting based upon cell location.
"See if.....already in spreadsheet" - What should be done if it doesn't find this number? What if there are multiple numbers found?

I am going to needmore specific information to continue.

stnkynts,

I was referring to the Submittal Numbers. I want the spreadhseet to be searched based on the Submittal numbers. If the submittal number that is inputted by the user is found in the spreadsheet then the information which the user inputs for all the other fields will be inserted in the spreadsheet after the found submittal number. If the submittal number which is searched for is not found, then the input from the user should be placed at the bottom of the spreadsheet. And if there are multiple numbers it should place the information after the last number which was found.

Does that make more sense? It makes sense in my mind, knowing exactly where i want/need to go with this, but i am not sure if it makes sense when trying to explain it.

Thank you so very much for all of your help!

Originally Posted by stnkynts

I started working on this then realized what you said in your posts and what you have as data on your sheet makes no sense.



"User's input of a number" - What input is this? Do you mean the CDRL ID #? If so your supplied data has only 3 numbers in an odd orientation with different formatting based upon cell location.
"See if.....already in spreadsheet" - What should be done if it doesn't find this number? What if there are multiple numbers found?

I am going to needmore specific information to continue.

There are still quite a few issues. I addressed as many of them as I could. The userform_initialize has some problems I didn't address.

Please Login or Register  to view this content.

Thank you very very much! I will continue to work on it and try and figure out the issues.

You cant just move code around as you did. For example why did you move these lines of code to a textbox_change event when the variable LR was being used under a different subroutine.

Please Login or Register  to view this content.

If you are trying to have the row inserted immediately once you enter a value, you would just need to publicly declare the variable so the other subroutine can access it.

As to your question about the Run-Time Error, I was not able to duplicate it.