VBA Userform Data Entry - Reference Number problem

[TalResha]

Hi Guys,

Me again and I have another problem I cannot seem to work my way around.

I have a userform that will allow the user to enter in new data, however, the first column in the sheet where the data is contains reference numbers.

I need the userform entry TextBox1 to be last reference number in the sheet +1 so that each new entry gets the next reference number in the line.

So Column A Row 2 has the reference TestRef1, I need the userform to state in TextBox1: TestRef2 and so on...

Please help me as this is for a project that I am working on.

Thanks!

[MaczaQ]

try solution from attached file

Best Regards

[snb]

Please help us by posting a sample workbook, illustrating your question.

[snb]

@Maczaq,

This suffices: (no need for Textbox1)

Please Login or Register  to view this content.

[MaczaQ]

@snb

thanks for showing me other way.
Works great, and I will consider to use this kind of output data back to sheets in my projects

Good bless You !

[TalResha]

Keep getting a type mismatch:

.Offset(1).Resize(, 2) = Array(.Value + 1, TextBox2.Text)

[snb]

Please Login or Register  to view this content.

[TalResha]

Hi snb,

Still the same error, not sure what is going on here...

It might be because I have two userforms, one is where the user selects input new site, and then the input new site userform pops out.

Also, the sheet I need to pull the reference data from is called Details and for some reason I cannot call that sheet up through this code..

HEEELP!!!

[snb]

Please don't yell but post a sample workbook instead....

[TalResha]

Hi snb,

Wasnt yelling, sorry about that, forgot that CAPS in forums mean yelling

Find attached a sample workbook.

This is much more simplified from what I am working on, but should cover what I am trying to do with this part of the code.

The details sheet is hidden, and column A has the references.

Thanks for all of your input and for all your help in this

[snb]

I never heard someone whispering 'help'.

[TalResha]

Hahahaha, true

Hopefully the sample workbook will aid you in your quest to help me

[snb]

What's the point in repeating "Ref_" ? while the column label is data_reference ?

If you like to keep this you can use the numberformatting "Ref_"0000
Now the content of the cell will be 1,2,3,4,5, etc., but is will be shown as "Ref_0001", "Ref_0002", etc.

[TalResha]

Hi snb,

Again, thank you for your input, however, the Ref needs to stay there as this data is then migrated into other sheets for reporting purposes. I know it is a bit of pain but

If you can set it up like you explained above that sounds good as I am not too sure how that would work

Again, your input in this is greatly appreciated

[snb]

Using the explanation you will be able to implement this yourself.