Hi Everyone, I'm working on a project and am new to VBA. I've followed tons of tutorials online but I am stuck trying to delete a row in my table based on a selection made in a listbox within a user form.
The purpose of the userform is to collect data on reallocating medication that was taken...
Hello. I would like delete a button if it exists. I cannot find the syntax that allows for the case where it doesn't exist. I would like something like
If “CommandButton1” Exists Then
ActiveSheet.Shapes(“CommandButton1”).Delete
End If
I'm not sure how to write the condition. The Delete part...
Sir, Ma'am,
I have a piece of code that locks a cell down after the user selects items from the drop-down list associated with the cell. There is a button on the adjacent cell to the right that needs to be automatically deleted when several items of the drop-down list are chosen. The drop down...
Hello, this is my first post. hopefully i can finally get some hkpe. Ive searched high and low for an answer via google, forums, youtube, you name it ive tried it. Anyhow let me give some background first. I have no previous VBA experience and all that I have learned has been int he past week...
I have a quotation form that have two buttons.
One is click and will generate a new quote number.
Another is click and it will be save with the assigned path and file name format.
When I click on save File, the new saved files will also copy the buttons and macron, which I like to delete the...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.