Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBE Form in excel
I have created an input form in VBE and use it to populate a worksheet, I
would also like to select a record(Row) on the worksheet using a combobox and repopulate the original form for editing information? Also, in my combobox, sometimes highlighting a selection pulls up a different selection? Any help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBE Form in excel
If I understand what you want, I don't think using a combo box to select a
row is the way to go. I do a similar operation in an application and what I do is have the user type in the row number that they want to edit information on and click a button which then populates other textboxes on the form with data from that row on the active sheet. They then edit the data on the form and finally click a [save changes] button to put it back into the proper cells on the worksheet. As for the combo box seemingly not pulling up the proper information, without seeing the code associated with the control, the list it is being populated from and the data on the worksheet, it's hard to say why it doesn't seem to be working properly. "John" wrote: I have created an input form in VBE and use it to populate a worksheet, I would also like to select a record(Row) on the worksheet using a combobox and repopulate the original form for editing information? Also, in my combobox, sometimes highlighting a selection pulls up a different selection? Any help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a form made in Excel 2002 be converted into a fillable form? | Excel Discussion (Misc queries) | |||
how to generate a unique form # when using an excel form template | Excel Worksheet Functions | |||
How do I put my information form Excel into a Word Merge Form? | Excel Discussion (Misc queries) | |||
I created a form on excel. want to edit the form without printing | Excel Discussion (Misc queries) | |||
Is there a way to convert a EXCEL form into a WORD form? | Excel Discussion (Misc queries) |