form buttons

  1. A

    using Form as MsgBox in a code

    Is there a way to use a customized Form1 as Msgbox? like: In my program I have a big Form and a button that calls this customized Form1 in some conditions and I have an If statement after that depending of the choice. What I need is like: If Form1.click= "fist button" then 'code end if (of...
  2. D

    Excel Accelerated Buttons Working Only Once

    I've developed a simple user form with a bunch of buttons that, when pressed, play a sound. I've also assigned a custom "accelerate" key to each button in a manner which when I press Alt + key the button is activated. The problem is, this happens only once for each button! Every subsequent...
  3. D

    Using Excel like a database - need help with Form filling a table acting as the database

    Hey Guys, Im new to VBA and Im having trouble with a project Im working on. I've created a "database" within excel that you populate with a Form. I've got most of the functions working, but Im hung up on one bit. The logic of the Form entry works like this: When the Form CommandButton is...
  4. L

    User Defined TextBox value with Command button search to return another field values in another textbox

    Hello, I am trying to create a user friendly Form that preforms three functions: Allows the user to enter their User ID "txtParentId". ******* procedure to use the User ID entered to pull the related field data from the table "cmdSearch" Fill the first column into the first textBox...
  5. D

    How to track form control changes

    Hello VB experts I could really use some help on recording changes to a a form control such as a check box. I have the check boxes associated to cell ( one for each control different control) I have this code to record changes to a "log" sheet. It is working fine but when I check a check box or...
  6. V

    Can you assign multiple click events to a button?

    Hello Excel Community, I have a control sheet that runs a variety of macros in my workbook, but I'd like to reduce some of the formatting control buttons if possible. Basically, I have some procedures that only hide or un-hide rows/columns for presentation purposes, but I'd like my users to be...
  7. R

    How to assign a macro from one sheet to a form button on diffrent sheet

    Hi, I am running excel 2010 with windows 7. I created a macro in sheet 1 and I wish to activate the macro from sheet 2 using a form button. I have entered the code below. I know how to perform this function on a more simple macro like adding names to cells. This code is a bit more complex I...

We've detected that you are using an adblocker.

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.
Go back
Back
Top