Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Recall function to a User Form
Hi
I have developed a user form that inputs data into rows in a worksheet. The problem is, is that some of the data sometimes needs to be changed later on. I was thinking that a recall button on my userform could work, but I need it to recall the information on a specific row back into the input fields on the form, that can be edited and then re-submitted back to my list on the spreadsheet. Any help with code would be appreciated Or if this is just a dumb ass way round of doing it...sorry, but i am still learning THANKS in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Recall function to a User Form
Hi I can't think of a 'dumb ass' way to do this. However, you could have a drop-down which allowed you to select a row and read in the values. This would be linked to the listbox change event. Hope this helps. Martin http://homepage.ntlworld.com/martin.rice1/ -- mrice ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=532118 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User form and hiding spreadsheet | Excel Discussion (Misc queries) | |||
User Form in VB = TextBox | Excel Discussion (Misc queries) | |||
User Form Formula ? | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
how to move user defined function | Excel Worksheet Functions |