Search and insert values in sheet from user form

**sabeelahmedks** · 01-17-2018, 06:54 AM

Hi, I have created a form in which i have used some codes to get the student data from sheet1 and perform some operation and saved in sheet2, till this i have done, now i want to to save the userform data based on the roll number and month of the fees paid by the student in sheet3.

I have attached my user form and sheet

FETY.png

The same concept i have used in my another workbook to copy the data from sheet to sheet with the below code.

Please Login or Register  to view this content.

many thank in advance.

BR
COOL SAB

**mjr veverka** · 01-17-2018, 09:45 AM

There are different ways, it all depends upon your preference, e.g.:

Please Login or Register  to view this content.

Edit:

Version with your code:

Please Login or Register  to view this content.

**sabeelahmedks** · 01-18-2018, 12:10 AM

hi porucha vevrku, i got some compile error, as i have change only sheet name and some values in user form which i have highlighted in the below image.
please advise to how to proceed further, many thanks in advance.

error.png

BR
Cool Sab

**jindon** · 01-18-2018, 12:39 AM

Alter control names to actual ones.

Please Login or Register  to view this content.

**mjr veverka** · 01-18-2018, 05:39 AM

Originally Posted by sabeelahmedks

... i got some compile error, as i have change only sheet name and some values in user form ...

1. You should use not the name of the sheet itself, but the constant that stores this name
2. strID = "A1002" and strMonth = "May" are not numeric values but strings - not 'Val' function
3. 'amount' (strAmount = "600") yes, this "can be" a numeric value, then Val(Me.TextBox2.Text) and change the declaration of this variable to 'Double' (i.e. Dim strAmount as Double)
4. Try the example of jindon, it is extremely short

Search and insert values in sheet from user form

LinkBack

Thread Tools

Rate This Thread

Display

Search and insert values in sheet from user form

Re: Search and insert values in sheet from user form

Re: Search and insert values in sheet from user form

Re: Search and insert values in sheet from user form

Re: Search and insert values in sheet from user form

Thread Information

Users Browsing this Thread

Similar Threads

User form to Search Data and Insert

Using a user form to insert a new row

Create User form to perform search using multiple search criteria

[SOLVED] User Form to execute search and return all values to the user form for editing

User Form to Search/Display multiple criteria on a seperate sheet with use of hyperlinks

how to use VBA to search and return search result in the user form

Search and create a register with values inserted into user input form

Bookmarks

Bookmarks

Posting Permissions