Show data from a selected row in an excel userform

Hi all,

I wanted to know if it is possible to show the data from cells that are in a choosen row into an excel userform. This way when I select a row (the first cell of a row) and click a button, the userform will open and show me in fields all the information that are on the cells in that row.
Please let me know if this is clear or need more information to be able to say if it is possible.

I know how I can add a new row with data filled into fields in the userform, but don't know how to get it back into the userform once selected that row.

Any help would be great.

Thanks in advance.
megatronixs

Hello John,

This is really magic. It works really great :-)
If I would like to add some buttons to put the current date into the third cell, is that also possible? I was thinking of adding a button next to the text box that once pressed it will show the current date.
When I click the button ĻupdateĻ does it also saves the data in excel? or do I need to save it when the form closes?

Thanks a lot for your help :-)

Greetings,
megatronixs

Hello John,

Great help again. It works great. I have one more question. Is it also possible to create reports from the data that would look like the ones in Ms Access? And would it also be possible like in Ms Access to insert the date that is in the text box from the form to the next available cell in the same row? Let's say I have a text field for customer order and in there I put the number of the product ordered, when he orders a second item, it will show below the first one in the userform, but right of the previous one in the sheet.
Maybe I'm just shooting arrows in the dark, but I don't have access available and lacking the knowledge to do so.

Greetings and thanks again :-)
megatronixs

Hello John,

Thanks a lot. Maybe there is a way to put the information from the cells (filled in with the userform) and print it out that looks like a letter?
The ultimate goal of the whole thing is to produce a letter with all the data collected in the userform by the click of a button.

Thank you again for your effort.

Greetings,
megatronixs

---------- Post added at 11:03 AM ---------- Previous post was at 10:58 AM ----------

Hello John,

I just forgot one silly question. Is it possible to implement one more button that could duplicate certain fields into the next row. to avoid filling up the same data a few times. this could be let's say B2, C2,D2 and E2 (as an example).

Greetings,
megatronixs

Hello John,

Thanks a lot :-)
These where the building blocks I just needed to get this starting. Now I can finish this super userform.

Thanks a lot for all your help :-)

Greetings,
megatronixs

Hello John,

Sorry to come back again with questions. What if I would like to insert a calendar box in the form. This would be a button that when pressed shows a calendar and after selecting a date, it inserts it in the field. With this I would like to avoid that people start putting there different date formats.

If I ask to much, please let me know. VBA is still kind of magic to me and finding my way around is not that easy for a beginner :-(

Thanks in advance,
megatronixs

about Lady Gaga, I hope she does not hang to long around here ;-)

Woooooooow,

Thanks John, this is really cool. And if I would like to combine two fields with one button that when I press it, it will insert the today's date and fill in a second field the person pressing the button (the excel user name). I just don't get that part to be filled in. Now I have a second button that when pressed, it puts the user name there, but would be nice to combine those two.

John, I'm learning VBA as much as possible and discovered the userform some time ago. Can I ask you where did you got the knowledge about userforms? is there a specific book that you can recommend? I would like to be able to do all this by myself without having to bother other people with to many questions.

BIG thanks for your help, I really appreciate it :-)

Greetings,
megatronixs

Hello John,

I know that Application.UserName will put the name of the excel user, but I can't combine that in:

ws.Cells(iRow, 4).Value = Me.TextBox5.Value 'this is a new textbox and add yr value/text in column 4

Is there a way to combine these two so it will add both at the same time (date in textbox4 and username in textbox10)?

Thanks again.

Greetings
megatronixs

Hello John,

Oops, it is me again :-)

A silly question. Is it also possible to add a spin control button and let it go up or down a row?
I was thinking of adding a type of navigation so one could have a quick look trough the clients
without having to close the form every time.

Thank you in advance.

Greetings,
megatronixs

Hello John,

Thanks a lot. Finally I managed to do it. I just missed one more group to change the a to b.

with bellow I noticed that shifting all the "offset" -1. So 0 became -1 and now it works correct as I changed from row A to row B.

Please Login or Register  to view this content.

This means that if I add more text boxes, I will have to add the offset values for them as well.

This forum and especially this thread is turning in a great learning experience !

Thanks again for the great help and being around when needed :-)

Greetings,
megatronixs

I also have noticed that if one new row is added (by selecting the row that has no data yet in column A), it will of course not update and it will look strange in the listbox.
When you exit the userform and return to it, it will be there. (important is to push the "update" button to save the changes.

I hope many can profit from this thread as it is very good to know more about the power of an excel userform ;-)

Hello John,

I have one more question for you ;-)
Is there a possibility to add a button that will go to the next empty row and allow me to add new data?
and at the same time looking at the previous cell and add +1 to the number (ID number)
Now to do so, I need to close the form and then select the next empty cell.

I;m trying to find a solution for this, but some how I don't get it what is needed.

Thanks in advance,
megatronixs

Double post per accident