Facing problem while saving data in desired cell in excel sheet from your form

**Harmeet Singh** · 11-18-2013, 02:42 AM

i am new in VBA excel programming, i made a form to save marks obtained by the students in exams. While saving these marks i need to save these marks subject wise and between 2 subjects i need 3 rows to calculate total, percentage and grade. Program working fine till here and data goes in their given cells, but when i enter record of second student instead of going to next row this data goes to the same row, and over write the previous data, so i am facing problem in saving the next record in next row, But if i remove the 3 cells which i leave blank to calculate total, percentage and grade, then there is no problem in saving data in next row, so the problem lies in saving data while leaving 3 columns blank in 2 subject and finding new row, i am also attaching the file. So plz help me to find the solution for this problem. Thanks.

**xladept** · 11-18-2013, 02:52 AM

Try this:

Please Login or Register  to view this content.

**HaHoBe** · 11-18-2013, 03:09 AM

Hi, Harmeet Singh,

i stands for Integer, and irow should be of Type Integer according to the prefix, not Long. Why use a With-Statement for the worksheet and preceed any range with the worksheet object?

Please Login or Register  to view this content.

Ciao,
Holger

**Harmeet Singh** · 11-18-2013, 12:05 PM

Dear xladept ,
First of all thank you so much my friend for helping me, well i am using same code in my programming, it is saving data where i want but it is not saving new record in next row, its replacing the data saved earlier in same row! but if i am not leaving 2 cells blank in the row and save data in continues cells, then it save the next record in new line!

**xladept** · 11-18-2013, 03:38 PM

Hi Hameet,

Maybe:

Please Login or Register  to view this content.

But if Column B is one of your blanks cells, then use another column for your next row determination

**Harmeet Singh** · 11-19-2013, 04:07 AM

I have tried the other method you asked me to try in second time, but still its not saving the data to a new line!

**HaHoBe** · 11-19-2013, 04:36 AM

Hi, Harmeet Singh,

maybe give this code a try:

Please Login or Register  to view this content.

You could insert commands to fill the cells with the formulae in the code (or Autofill to the next row).

Ciao,
Holger

**Harmeet Singh** · 11-19-2013, 05:24 AM

Hello Holger, Thanks for you time and support, i am going to try it and will give you feed back soon!

**HaHoBe** · 11-19-2013, 07:42 AM

Hi, Harmeet Singh,

seems to be an odd day for me - lHelp isn´t the same as lngHelp

Please Login or Register  to view this content.

Ciao,
Holger

**Harmeet Singh** · 11-19-2013, 08:47 AM

Hello holgar, thanks for unconditional support. I want to ask you few more things, do you have a Facebook account or yahoo messenger? So that I can chat with you directly?

**HaHoBe** · 11-19-2013, 09:55 AM

Hi, Harmeet Singh,

neither nor. And I haven´t used my Skype Account for years either. Plus I´m not at home for the time being. But you may ask here at any time.

Ciao,
Holger

**Harmeet Singh** · 11-20-2013, 12:07 AM

Hello Holger, sorry for disturbing you again, i was trying to insert the code given by you in my code but was not successful. So i am pasting my code here, will you plz add you code in my code? Thanks you so much

Harmeet

**Harmeet Singh** · 11-20-2013, 03:16 AM

Hello holger,
Thanks so much for you help, i applied the first code (sample given below) you sent me in my program and it start saving data in new row and also leaving 2 columns blank as i want.

This code was for 2 subjects, but now i need to add 5 more subjects in it, means after every 3 columns i need two blank columns, so how can i do this, i am also trying at my level, but i will be very thankful to you if you help me in this.

regards
Harmeet

This is the program which is working

Please Login or Register  to view this content.

**HaHoBe** · 11-20-2013, 05:11 AM

Hi, Harmeet Singh,

you would need to wrap your procedures with code-tags as requested in Forum Rule #3 before anybody should answer your questions.

Ciao,
Holger

**Harmeet Singh** · 11-20-2013, 07:06 AM

Hello Holger,

Warped the procedure in code-tags. So will you please tell me how i cam make it working for 5 subjects like i mentioned in previous post?

Regards,
Harmeet

**HaHoBe** · 11-20-2013, 07:28 AM

Hi, Harmeet Singh,

the old code looked like

Please Login or Register  to view this content.

You would need to add the additional TextBoxes in order to avoid a run-time error (maybe use Format to show leading zeros). The altered code may look like

Please Login or Register  to view this content.

Ciao,
Holger

**Harmeet Singh** · 11-23-2013, 02:41 AM

Book2.xlsm well i made this program to save data in desired cells where i want it, with the help of very kind a nice persons's help, but it is giving me a little error when i am running this program, i am attaching the code here, plz help me to remove this error!

**HaHoBe** · 11-23-2013, 03:39 AM

Hi, Harmeet Singh,

your code runs a loop from 1 to 23 while the highest number of the textboxes on the UF is 13 - not so surprising that a run-time error is raised when Textbox14 isn´t found.

Code behind the UserForm:

Please Login or Register  to view this content.

Ciao,
Holger

Facing problem while saving data in desired cell in excel sheet from your form

LinkBack

Thread Tools

Rate This Thread

Display

Facing problem while saving data in desired cell in excel sheet from your form

Re: Facing problem while saving data in desired cell in excel sheet from your form

Re: Facing problem while saving data in desired cell in excel sheet from your form

Re: Facing problem while saving data in desired cell in excel sheet from your form

Re: Facing problem while saving data in desired cell in excel sheet from your form

Re: Facing problem while saving data in desired cell in excel sheet from your form

Re: Facing problem while saving data in desired cell in excel sheet from your form

Re: Facing problem while saving data in desired cell in excel sheet from your form

Re: Facing problem while saving data in desired cell in excel sheet from your form

Re: Facing problem while saving data in desired cell in excel sheet from your form

Re: Facing problem while saving data in desired cell in excel sheet from your form

Re: Facing problem while saving data in desired cell in excel sheet from your form

Re: Facing problem while saving data in desired cell in excel sheet from your form

Re: Facing problem while saving data in desired cell in excel sheet from your form

Re: Facing problem while saving data in desired cell in excel sheet from your form

Re: Facing problem while saving data in desired cell in excel sheet from your form

Re: Facing problem while saving data in desired cell in excel sheet from your form

Re: Facing problem while saving data in desired cell in excel sheet from your form

Thread Information

Users Browsing this Thread

Similar Threads

Hi Guys, am facing problem while doing some excel calculations

[SOLVED] EXCEL USER FORM- data not saving to sheet 3

[SOLVED] Facing Problem with VBA Excel on Pulling data

I would like to create a simple code for data entry form with data saving in excel sheet

Facing problem in excel while copying data from one sheet to another sheet

Bookmarks

Bookmarks

Posting Permissions