Stack Overflow
Stack Overflow

Questions tagged [commandbutton]

JSF tag to create a POST botton.

The <h:commandButton> is a JSF UI component which generates a HTML <input type="submit"> element which submits its parent <form method="post">.

456 questions
0
votes
1 answer

Copy rows to a new sheet using command button

I am attempting to use a command button to copy rows to a different sheet in my excel workbook. I hope to type in the row number and have the VBA copy the row into a worksheet called "6.2022 Basis". My issue is "6.2022 Basis" has over 150 rows and…
jmowalker
  • 1
  • 2
0
votes
1 answer

Generating ActiveX Command Buttons and assigning code to them externally in VBA

I'm working on a task where it needs to generate ActiveX Command Buttons dynamically and assign certain code to them automatically. Each time I close the Worksheet, the command button needs to be deleted (it is completed), but code for that button…
JoeStar
  • 83
  • 1
  • 7
0
votes
1 answer

Slow loading time in excel from VBA for combo box and command button

I created an excel template so I can type in a name and pull from a dropdown list, then populate the next empty cell in a column with the name at the click of the . It works, but is very slow. I used some tricks I found online to help speed it up,…
Schiro42
  • 1
0
votes
1 answer

Run a Macro from Shape or `Button (Form control)` leads to hang the Excel Ribbon, Office 2016 32_Bit

This issue can be produced only on Office 2016. I have a sheet with name Test , then I hide it manually or by this code: Sub Make_Sheet_Hidden() Sheets("Test").Visible = xlSheetHidden End Sub Problem: If the below code Make Visible assigned to…
Waleed
  • 847
  • 1
  • 4
  • 18
0
votes
0 answers

Date Picker issue - Monday - first weekday

In the USA, the first day of the week is Sunday, but in many European countries the first day is considered Monday (see the attached captures). I was able to make it show the calendar accordingly, but there is an issue regarding the colors. Sunday -…
Dan Enache
  • 1
0
votes
0 answers

Get the name of the Command Button I just clicked

I'm new to VBA and stuck with my project. I have several Command Buttons on my worksheet and they all refer to an ID that should be used later on for calculations. I named the buttons Button_ID1, Button_ID2, ... The idea is that I extract the name…
Banki67
  • 1
  • 1
0
votes
2 answers

How can I ensure that a Shape will appear on top of a Command Button in my Worksheet?

I have a toolbar with ActiveX command buttons for automating email generation. One of the buttons, ROV, stands for “Reconsideration of Value” and has to do with appraisals. Users tend to forget what ROV stands for, so I created an ActiveX Shape as…
Michael Riley
  • 1
  • 2
0
votes
1 answer

removing Buttons when exporting to PDF

I am trying to remove or hide the 4 commandbuttons when exporting to PDF. The way I do it works for the first time exporting but if I export the same file again, I'll get an error referring to this line: Me.CommandButton3.Select even though all…
Jens1411
  • 3
  • 4
0
votes
2 answers

Command button in excel to open hidden tab and jump to that tab

I am not very experienced with VBA and hoping the community can help me with a challenge I am facing. I have an excel workbook with about 20 tabs. I am trying to accomplish the following: When the user opens the workbook, only one main tab…
Gdata0data0
  • 43
  • 6
0
votes
1 answer

On clicking Command Button, copying and pasting data of same range from one sheet to another

I want to create a Command Button clicking on which 4 copy-paste functions are performed one after another as under: First Function: Data of Range A1:J500 are copied from sheet "Data3" and paste in the same range of Sheet "Data4". Then, Second…
ASMRH
  • 1
0
votes
2 answers

Another Macro works only in debug step mode question

Good day everyone! I've been slowly teaching myself on utilizing vba and after some brief success, have ran into a slight issue. I have two command buttons, one inserts a new row and populates 4 cells in row 8 while copying the number and formula…
Michael Bauer
  • 1
0
votes
0 answers

Command_button in VBA inside vs Shape with Assigned Macro

I am trying to write a script for extracting data from web inside a userform. I am using Get Data From Web option in Excel (2019). The data gets updated when I refresh it manually or even when I do it with a macro assigned Autoshape. However, I have…
Suman Razz
  • 1
  • 2
0
votes
0 answers

JSF h:commandButton is not working inside h:DataTable

I'm trying to delete a specific data in a table, i try to get the column id by using commandButton but it doesn't work, i tried to just show a message in the console when the button is clicked but no luck at all, i tried also some solutions that…
Yuu
  • 49
  • 8
0
votes
1 answer

`If` condition with multiple `And` does not get the expected result

Using a conditions to allow a button, I still didn't get the expected result. The button is not taking into account the conditions mentioned. How come Private Sub CONFIRM2_Click() If NAMEC.Value = "" And DATEC.Value = "" And CREF.Value = ""…
otogap
  • 1
0
votes
1 answer

Userform Command Button Next (Matching Criteria)

I'm not an experienced coder, so please excuse my ignorance. I have written a piece of code that cycles through responses from an online request form, where the results are saved to a spreadsheet. There is a couple of problems I have, the first…
Welshdpm
  • 49
  • 9
1 2 3
…
30 31