Userform to Search/edit and overwrite an existing dataentry.

[prasanna]

My Dear Experts, Good evening,

I've tried to make userforms for a succession plan office project.

The information is shown in textboxes and I expect the changes made in those textboxes will overwrite the existing initially entered information in the "Sheet1"; but that's not happening.
I also wanted to have a combobox with just the company name to filter/dropdown.
The template is attached herewith.

Please do the needful.

Prasanna

 

[Luke M]

Hi prasanna, and welcome to the forum!

Since you want to be able to edit the source data, and be able to filter, I'd suggest using the built-in data form. To access, you can use this short macro.

Sub BasicForm()
Range("A1").Select
ActiveSheet.ShowDataForm
End Sub

In Office 2010, form looks like this:


You can edit the data in real time, create New records or Delete, and apply basic criteria (such as 'Sony' for company name).

 

[Chihiro]

Neat! Never knew about this functionality.

Much easier than using custom Userform for table editing.

 

[Somendra Misra]

Hi Luke & Others,

I think in Excel 2010 you can add the shortcut to Quick Access Toolbar for this form. So the file need not be saved as .xlsm. Just click inside any cell in table and click the form button.



The same can be added by customizing QATB and select All commands and than select Forms.

Regards,

 

[Asheesh]

Awsome...This is a very useful technique..@Luke M

 

[prasanna]

Thank you so much Luke..

Wonderful ! Never knew about this functionality.


Regards
Prasanna