I have been doing Excel VBA for over 10 years but I never got into the form section of Excel and I don't even know how to.
I have a button and assigned it to a macro and I have used this macro in several places but somehow one of the buttons got renamed. I am told I need to get into the Form...
Can someone help me get a way to generate ID's by avoiding duplicates and permanent values, unless changed manually.
Lets say I have:
<tbody>
A
B
C
D
E
F
1
Country
State
City
Submarket
Use
ID
2
Mexico
Baja California
Tijuana
Florido
Industrial
MBTFI-0001
3
Mexico
Baja California
Tijuana...
Is there a way in VB that if a value of a cell is equal to 0, it can resize the height of row and highlight it red?
If someone can point me into the direction of the height property, I can probably figure out the code. I appreciate any help.
I have an Excel 2003 spreadsheet with a macro that makes a copy of the last sheet and does some minor updating of the data to prepare for the next day's entries. I change the sheet tab name to the calendar date. I have this in a number of our remote locations working fine. There is one location...
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.