I have a number of buttons on a spreadsheet. I want to click the button and it tell me which column/row it is on, msgbox would suffice.
The button will only be in a single cell so there will be no overlapping.
Is there a way for a button to know where it is sitting on the spreadsheet.
I have never written or used a macro before and I have a simple macro task to complete:
I have Column L (L4:L10) of seven scroll bars that move according to number changes in column F (F4:F10). I want to create a form control command button that resets the changes on the scroll bars according to static column of numbers in Column E (E4:E10).
I don't know if it matters, but I'll add that I plan to add a second button that does the same thing with a different column of data. I assume I'll simply replicate whatever procedure I use in the first button - is this okay?
Here is what i am currently using as code for one of my 56 or so buttons:
View 3 Replies View RelatedOk I have a form where our employees enter in some info and press the add button. I want this add button to take the data entered and transfer it to a database. Each time the button is pressed it needs to drop a row and add the new information entered.
View 8 Replies View RelatedI have a column ("R") which contains prices. What I'm looking to do is have a form control button that either hides that column, or better still just turn the font white (invisible)on the press of the button, then with another press turn the font back to black (visible) or do I require 2 buttons to carry out this function. I don't wish to have the column formatted in anyway after the changes, simply 1 press turns the font white and either another press (or another button) turns the column back to the exact same state (no formulas present) as it was.
View 10 Replies View RelatedI have several files with form control buttons that automate functions but, on occasion, they get smaller relative to the worksheet they're in. At some point, they become unuasable unless they're manually resized.
View 8 Replies View RelatedI have a rather large sheet with lots of embedded form control buttons, each one with a document link. Is there a function (no VBA) to search for a specific form control button in excel? for example: i want to find the form control button which is linked to the "application" document.
View 8 Replies View RelatedIs there a way to force a control botton linked to some VBA code to run the macro on not the first, but the second click?
I have added a button to asign a macro to but for the life of me cant see how to "activate" the button. I am trying to click the button to make the macro run but it keeps selecting the button like it wont come out of design view.
View 4 Replies View RelatedI have made an excel sheet for multiple choice questions, in which person needs to click on submit button after completing with the test & pop up will say "Your score is__". Now, I want to want to add one more button named "Reset". I want below :
results:
1. Person should not be able to make any changes after clicking on "Submit" button.
2. If one tries to click on "Reset" button, it should ask for password.
3. After keying password for "Reset" button, all questions should be reset so that next person can give test.
I have attached an example excel sheet for reference : DoM1.xlsm‎
I am trying to get a form sent as an email by pressing he control button without having to cut and paste into an email sheet. I have tried with
[Code] .....
but the code I put in only opens a new email form, which requires cut and paste.
I have created several macros where i use an active-X control button. This button is pressed and the macro begins...........but every now and again this button changes size for no apparent reason.
I have read countless articles/posts about what "may" be causing the problem but i have never read anything which clearly identifies the soln to this problem and the problem has been out there for years. To make matters worse the problem can not be duplicated on any regular frequency that i am aware of............so its not like i can post a file that will show the problem.............
I would like to know how to configure buttons:
In tab Sheet1 there is Commandbuttons named "Sheet2" & "Sheet3". If i press "Sheet2" then i will be directed to sheet2 tab, same as "Sheet3". In tab Sheet2 & Sheet3 there is commandbutton "Sheet1", if i press the button then i will be directed to default tab which is sheet1.
Is it possible to configure the workbook so the user can view the data in the worksheet from the form and I can hide the actual worksheet so that the data in the workshhet cannot be changed? Or maybe there is a better way all together??
I am attaching a copy of the worksheet.
Second, Is there a better way to input a code that would allow a search for duplicates in certain fields to be flagged (other than the color coding?)
I Have a sheet with 4 activex comboboxes and 3 text boxes. If the right item is selected in the second combo box a user form opens up. That has 4 text boxes. It has a command button titled ok that takes the information from the 4 text boxes and puts them in a sheet called data.
Code:
Private Sub cmbOK_Click()
With Worksheets("Data").Range("A1")
.Offset(1, 8).Value = Me.txtFirm.Value
[Code]....
I need a way for the above code to run when the ok button on the user form is clicked.
Is it possible to use a Form control which choose a folder/file in a specific location (Ie: Browse button)?
Currently I put the location details in a textbox.
I am using the following code to copy a template to a new worksheet each month:
Code:
Sub CopyTemplateNewMonth()
Application.ScreenUpdating = False
Dim SourceRange As Range, DestRange As Range
[Code]....
Everything copies over except an Activex Control button. I also have form control buttons with macros assigned to them, and they copy & paste just fine. The code assigned to the ActiveX button also copy's & paste's just fine...but the button itself does not.
I have created simple buttons on my spreadsheet to do most everything that is needed, except to display a "Help" file. The "Help" file can be a pdf document or any other document format that will work. I don't think I need any user forms or ActiveX controls. But, then again, I am a relative newbie to VB. Is there a simple way to have a button control on an Excel spreadsheet open and display a pdf file or other document? Or is there a better way to do what I'd like?
View 8 Replies View RelatedSo I have a sheet with a lot of formulas and form control buttons that have been assigned macros.
When I go to protect certain cells and lock them and the activate sheet protection, suddenly my form control buttons with the assigned macros don't work.
I still need to protect some cells with formulas and don't want to leave the whole worksheet unprotected, but in order to allow the form control button macros to run, it appears that's what I have to do....or, is there another way to do this?
Can Active-X control button macro be placed in a regular module, or does it always have to reside in the sheet module?
Or is the only way to accomplish this is to have the macro in the regular module being called from the button macro in the sheet module?
I somehow seem to remember a way to move/assign an Active-X ControlButton macro to a regular module, but maybe I'm wrong?
I have a control button on a worksheet that is suppose to call a userform. I am using the code
Frm_Customs.show
But I keep getting an error. The button was created from the control toolbox.
I am using the following code to create an Excel toolbar custom control Button. What would be the VBA code to change the color of the image I have chosen? ....
View 6 Replies View RelatedExcel 2010. How/where to define userform object?
Button on worksheet has following code:
Sub Button1_Click()
Load UserForm1
UserForm1.Show
End Sub
Execution of this code generates following error:
Run time error 424
Object required
How/where to define userform object?
is it possible to choose an option button which will then perform a calculation on a cell reference? I’m trying to deduct a percentage from a total when an option button is highlighted.
View 5 Replies View Relatedhow to change the color of a command button created by using the control tool box
View 2 Replies View RelatedInstead of having the goals and objectives already in the form I would like to have buttons that would allow my clinicians to add as many goals and objectives as they'd like to the attached treatment plan. I'd like them to be able to click a delete button as well when they review the plan and need to delete a goal that's been met. When my team clicks into the second worksheet they would see rows 10-16 (below). They would then type a STG 1 and an Obj A. They then would click the Add Obj button and add as many objectives that they needed. Then when they clicked the add goal button a blank copy of rows 10-16 (including the Add Obj button) would pasted one row down and would update to read STG 2. Neither of these buttons would appear when the document printed.
Here is a screen scrape of what I'd like the attached form to look like before goals and objectives are added.
add goal.jpg
The original form is saved in an .xltm format but I saved it in an .xlsm format so I could upload it here.
HCT ITP (2-25-14) Abbr.xlsm
I found a thread on this forum that came close to answering my question but my attempts to pull out the coding that I needed was unsuccessful. Here's a link to the thread: [URL] ........
See attached spreadsheet. It's an imaginery list of orders. Raw data on the left, summary on the right.
F is a reduced list of A, G is how many times each appears in A. H is supposed to be the total values of each order, ie quantity in B * value in C.
How do I calculate H?
I have the inputbox so i can set a string value,
When the inputbox Cancle button is pressed i want to exit sub,
If the inputbox value is nothink and ok button, I want the msgbox displayed then goto newname.
If the inputbox has a value do >>>>>>That>>>>>
I have a button for Column T that when clicked I would like to run through different column widths 25,35,45,55,65,75.
I've tried a case statement but it doesn't run through each case on the clicks.
Is there any way in VBA to refer to a control in its own event procedure without referring to it by name/hard-coding?
It might be clearer to explain by a dummy code example:
[Code] ......
I'm seeking what I would need to replace Line1 with.