Progress Bar To a button on a userfrom

**peels2141** · 07-05-2013, 05:56 AM

I have a delete form that finds the product ID in the first column and then deletes the entire row.. I wanted to add a progress bar to the button so when clicked the user can see when the item has been fully deleted.

This is my code

Dim rng1 As Range

MsgBox "Are you sure you want to delete this item?", vbCritical + vbYesNo

If vbYes Then

Set rng1 = Sheets("PRODUCT").Cells.Find(Me.txtDelete.Value, , xlValues, xlWhole)

txtDelete = ""
txtLayoutNo = ""
txtCategory = ""
txtProductDescription = ""
txtUnitPriceIE = ""
txtUnitPriceNI = ""

rng1.EntireRow.Delete

Else

If vbNo Then

Unload Me
FrmHomepage.Show

End If

End If

End Sub

Thanks

**Lifesigns** · 07-05-2013, 09:05 AM

Hi I did some code examples for progress bars a while back try the attached it should get you started.

One uses a userform with a custom label and the other uses the progressbar object, although I doubt the latter is available in Excel 2003.

**HaHoBe** · 07-05-2013, 09:15 AM

Hi, peels2141,

please remember to add code-tags to your code - thank you.

A ProgressBar for the deletion of one item seems a bit of overkill - won`t a simple msgBox do the same?

Please Login or Register  to view this content.

@Lifesigns:
which attachment? (sorry, didn´t see the update in the preview window).

Ciao,
Holger

**peels2141** · 07-05-2013, 09:29 AM

Hi Lifesigns and HaHoBe,

Thanks for your response. I completly agree with you HaHoBe the message box will work perfectly, and id say the progress bar would have affected the speed of the process even further being honest, so the message box works perfectly thanks a lot.

Peels

**zbor** · 07-06-2013, 02:14 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here