Excel UserForm - Cell Interaction assistance!

[desidude666]

Hello,

I am currently working on a personal project involving a userform and a couple of worksheets.

The form contains buttons (next/previous for a range "A7 - H7") and the user is to navigate the worksheet with the buttons, with cell data displayed in the textboxes on the form.

Could someone suggest how I could have this running? I tried:

Please Login or Register  to view this content.

At Form initialize:

Please Login or Register  to view this content.

However, since editing data is also one of the features, I wanted to first be able to navigate freely in the worksheet and have any data in the cell displayed in my elected textbox without a problem. Currently, on navigation, my buttons stop working after one click and plus there are a number of textboxes for a number of columns/rows.

To summarize:

I have to be able to navigate the worksheet with my buttons, and select a range of cells (in this case a7 - h7) and have my textboxes display the information. How do I navigate and display without limitations in VBA.

I am comfortable with VB, but VBA is a different thing and it's my first project... thanks for all the help, appreciated.

[Leith Ross]

Hello desidude666,

Welcome to the Forum!

You should post your workbook. It will be easier and faster to answer your questions by having all the code available and seeing the layout.

[desidude666]

Hi Leith,

Thanks for the reply, think that's a great suggestion.

The idea of this project is to navigate, edit and update information via an excel UserForm (I've done minor projects on MS SQL/Access back end) wanted one on Excel for some possibilities...

I might look to integrate some practical applications, maybe...

VBA is really another cup of tea, especially if you're not into the whole macro-affair!

The file:

http://www.mediafire.com/?sharekey=3...4e75f6e8ebb871

Just navigate to Excel > Tools > VBEditor (to the form...)

Thanks a lot.

[desidude666]

Hello!

Is there anyone who has an idea.

I think I tried loop for navigation of the active cell, but excel hangs. So does anyone have a better idea? Thanks.