Why does code called from a macro button to write data to an excel table work correctly, b

Please Login or Register  to view this content.

Worksheet “Sheet1” contains an excel table that has 6 columns, 40 rows with a header row beginning in worksheet row #7. The first 6 rows of the worksheet are blank.

When called from a macro button on the worksheet, the above code writes txtSTR to the cells in column 2 and 3 of row 9 in the table (corresponding to row 16 of the worksheet). This is what I would expect and want to happen.

However, when the same identical code is called from within a Userform, the data is written to the cells in column 2 and 3 of row 16 in the table (corresponding to row 23 of the worksheet) i.e. the right columns but wrong row. I’ve been trying to figure this out for some time now, without any joy. Maybe I’m not seeing something very obvious, but I would appreciate any insight. I understand that I could code around this by adjusting the rownum variable, but I’m really baffled as to why the code operated differently.

Are you using another variable called "rownum" in another procedure/scope that the userform could have initialized?

Otherwise without being able to see it myself I would say use "debug.print" liberally throughout your code. Check that the workbook is the correct one, the sheets correct, correct table, address of the table range, value of rownum variable, etc. by spitting it all out via debug.print lines added to your code.

In the context provided I dont see a blaring issue with the code, but if you have a userform then you presumably have other code too, which we cant see.

Thanks for the prompt replies.

My apologies. The sample code I posted does indeed behave the same regardless of whether it is called from a macro or from a userform. I will be a little more careful and less hasty before posting future questions. I am still very much a VBA newbie! Thanks again for your responses.