How do I bring a value into a Userform field?

**boninm** · 10-18-2017, 10:18 PM

Create a Userform with fields to track data of any kind.

2 sheets inside same workbook
- Sheet 1 - PartsData - database of data
- Sheet 2 - Menu that I'm working with

Clcik on Part Data Entry sheet
Click on Add Part Information. Msgbox will show the first empty row in the PartsData sheet
Then the form is displayed
I wanted to display the value number of the row that is empty in the form.

Click on close to close the Userform.

I've attached the file - PartsLocDB-02.xlsm

This is where I`m stuck. Can anyone help. Greatly appreciated.

**Keebellah** · 10-19-2017, 02:34 AM

Without looking at the file I would say that the moment you have selected a part the data is displayed sheetx.cells(x,y).value the same way you can sheetx.cells(x,y).row for the row or sheetx.cells(x,y).column for the column

**boninm** · 10-19-2017, 05:36 AM

Hi Hans

So, would that be coding that I put in a field in the Userform (and if so, what property?), or outside, and if outside, I'm guessing that it would be put before I load the Userform.

the data value is from sheet1, and I would like to display that data value in the Userform from sheet2
(I hope that it`s clear what I`m trying to do.)

**Keebellah** · 10-19-2017, 05:54 AM

The moment the form opens you can display the active cell row, and yes add a filed or you could even add it as a control tip text the shows up when you hover over the parts Id field
Your file throws an error due to missing control file, I think you use this dll for the date picker (I hate those things) so cannot really test it or for.
When form is initialized and you know the empty row you can add the controltip text some tile Me.TextBox.ControlTipText=activecell.row

**boninm** · 10-19-2017, 06:56 AM

Updated the form to remove the calendar option.

still not getting what I need to do.

Can you try to open the file and see what I'm trying to do

the msgbox will display the last empty row, which is what I'm trying to bring into the userform

thank you

**Keebellah** · 10-19-2017, 07:11 AM

I'm off to a meeting, won't be back 'till later this afternoon, will take a look then.

**boninm** · 10-19-2017, 08:08 PM

Thanks Keebellah

**Keebellah** · 10-20-2017, 03:16 AM

Add this code to the search form vba

Please Login or Register  to view this content.

**Keebellah** · 10-20-2017, 03:22 AM

I would however suggest that you replace the txtSearch box with a listbox or combobox that way you see the parts ID, the rest of the code would still work

**boninm** · 10-20-2017, 04:25 AM

Hi Keebellah

It works. Thank you very much for your help.

Greatly appreciated.

How do I bring a value into a Userform field?

LinkBack

Thread Tools

Rate This Thread

Display

How do I bring a value into a Userform field?

Re: How do I bring a value into a Userform field?

Re: How do I bring a value into a Userform field?

Re: How do I bring a value into a Userform field?

Re: How do I bring a value into a Userform field?

Re: How do I bring a value into a Userform field?

Re: How do I bring a value into a Userform field?

Re: How do I bring a value into a Userform field?

Re: How do I bring a value into a Userform field?

Re: How do I bring a value into a Userform field?

Thread Information

Users Browsing this Thread

Similar Threads

Inserting worksheet doesn't bring Userform

error VBA script trying to bring userform data from different then active sheet

How to bring second worksheets data in Userform ListBox2 ?

[SOLVED] Copy Data loaded via Userform to a worksheet named in 1 field of the Userform

Open Cell Link(Bring to Front) with CommandButton on Userform

Double clicking the results in Listview to bring up another userform

bring up a userform that searches

Bookmarks

Bookmarks

Posting Permissions