Search results

Hey everyone! Really quick... I enable Design Mode, insert ActiveX Control > SpinButton. I resize it to how I want it to look. I place it in one of the (500+) cells I need. It sizes up fine. I open the properties, I make the active cell H8. Now, when I copy/paste the control to every...

Chandoo - could I use Worksheet_SelectionChange? So that... when the cell isn't active (highlighted), the form control is hidden? I don't know HOW to do this but some searching provided a few indicators this could do that.

Unfortunately I have to account for a potential "infinite" number of reports. Basically, I'm monitoring a database that contains customer inquiries. As I note certain types of inquiries (say... billing related or product related), I want to track this with a number. Each time I notice this...

Hello! I want to maintain a clean appearance with a tracking sheet I've created. While looking at customer feedback, I am tracking the "types" of feedback received. Right now, I have to manually hop back/forth between my UI and the Excel sheet and manually type in say... 5 is now 6. I added...

Perhaps Developer Tab > Form Control > Insert > Form > Spin Button The place the button (left click on sheet), size it up, then right click on it and choose "FORMAT CONTROL". One of the tabs, you will see "Link cell". In your case, type in A5. Leave everything else as-is...