Run Time Error -2147024809 (80070057)

[Mel Smith]

I have three command buttons all using virtually the same code, but calling different sheet numbers. The first two buttons work perfectly but the third keeps displaying this error code whenever I select a name in TextBox 1 which is the same function in the other two). Command button one calls sheets as "sheet_num = Array (1, 2, 3). Button two calls sheets as "sheet_num = Array (14, 5, 6) and button three calls sheets as "sheet_num = Array (7, 8, 9, 10, 11).

Can anyone suggest what I might be doing wrong?

Many thanks.

Mel

 

[Mel Smith]

When de-bugging the follow line of code is highlighted:

Me.Controls("TextBox" & current_textBox).Value = .Cells(data_row, column_nums(i)) - although this line is the same as for the other two command buttons which work perfectly...

Mel

 

[Mel Smith]

Problem solved. One of the many text boxes had been removed (!?). Since I've replaced it and numbered it correctly, everything works. Every day's a school day!!