475 questions
3
votes
2
answers
113
views
Keep selection of InputText after callback in DearPyGUI
I am working on a simple quiz program that consists of multiple questions.
A snapshot of it looks like the following:
with dpg.window(label="Quiz Window", pos=(150, 0), width=500, height=300,...
- 190
0
votes
1
answer
92
views
Using input box inside a formula
I am trying to have a user input two cells by clicking on them, then applying the cell values not the actual values into the formula so it'll work on every row until the end of the sheet. Right now ...
- 27
-1
votes
1
answer
113
views
Making an Input Box in Pygame [duplicate]
I have just started with pygame and I wanna make two working input boxes, were you can write, delete, send (with the send key) and edit (just by re-clicking the input box).
P.S. Please don't make very ...
- 7
0
votes
1
answer
68
views
Excel InputBox: group shapes and name groups with unique names
This code allows the user to group shapes in a selected range and name the group with a unique name.
It uses 2 InputBoxes:
"1/2 Select Shape Range"
"2/2 Enter Group Name"
Bug: If ...
- 109
0
votes
1
answer
142
views
Excel InputBox: name shapes with unique names
This code allows you to add 2 shapes "oval" to a selected cell range and rename the shapes.
It uses 3 InputBoxes:
"1/3 Select Shape Range"
"2/3 Enter Shape Name shp1"
&...
- 109
1
vote
1
answer
632
views
How to get batch/powershell MessageBox and InputBox windows to display always on top of other windows?
I am writing a batch script to open a series of MessageBox and InputBox windows. The program works well when it is first launched and the users are able to interact with the windows, but if they click ...
- 11
0
votes
0
answers
74
views
No character limit input text Google app script
I have strings I need to process that are greater than 50,000 characters.
So, I can not paste these into a cell. So, I am trying to use an inputBox to bypass this limitation.
But I get Error resuming ...
- 350
0
votes
1
answer
159
views
Input box and Xlookup Function
I am new to VBA and trying to create a macro in VBA based on the following.
XLookup to count columns going backwards instead of a Vlookup. Once the formula finds the cell, then I would like to replace ...
- 11
0
votes
0
answers
48
views
How do I make an input box ask for a value that creates a pivot table immediately when the excel file is opened?
I have an excel sheet with a large amount of data (rows and columns)
I am trying to write a VBA code that will open an input box that takes a column category and makes it into a category on a pivot ...
2
votes
1
answer
158
views
number baseball game in javascript
I was making the number baseball game with javascript.
I got the random 3 numbers in my console based on the code I wrote.
And I want to use the function play for comparing the randomIndexArray which ...
- 21
0
votes
2
answers
115
views
Putting shape at InputBox Value
I want to make a Macro-Button, when you press it, a InputBox pops up and you can choose a cell. At that cell a shape should be placed. I have the following code:
Sub TrialwithDate()
Dim rng As Range
...
1
vote
1
answer
68
views
How to add an InputBox to search for words within all files in a designated folder
I use the macro below, created by Macropod, to run through all files in a designated folder to search for desired words.
How could the search terms be entered via an InputBox rather than manually ...
- 37
0
votes
1
answer
122
views
InputBox deselect the selection and return to initial state
I have a Blazor WebAssembly app that contains an InputBox with options.
When the is loaded for the first time, nothing is selected and shows "Please select an option" followed by the ...
0
votes
1
answer
120
views
Get name of worksheet selected using Application.Inputbox
I want to get the name of the worksheet I selected.
I tried this code from ChatGPT.
Sub GetSelectedWorksheetName()
Dim selectedSheet As Worksheet
Dim selectedSheetName As String
On ...
- 93
0
votes
1
answer
406
views
How to search all sheet names for values (partial matches)
I have a workbook with multiple sheets in a master roster book which are named based on a roster cycle number.
Each roster cycle will have varying named sheets with a common number to designate the ...
- 33
0
votes
1
answer
746
views
With help of Application.InputBox() method let user to select multiple cells
I have a code in VBA, where with help of inputBox method user is able to select a cell, a range. But I need to have an inputBox where user is able to select multiple cell ranges, ( not with help of ...
- 741
0
votes
1
answer
94
views
InputBox Date Validation
I have an update form. When a button is clicked, a Yes or No message box pops up asking the user to verify the delivery date.
Upon clicking No, an InputBox appears to enter the appropriate date.
I am ...
- 3
0
votes
1
answer
221
views
Add user input number to activcell value
I want to ask the user for a number, add that number to the value in the active cell, then place the result in a cell that is three rows up and two columns right of the active cell.
Sub AddNumbersB()
...
0
votes
1
answer
94
views
Insert a value into mutiple Excel files
I want to read multiple Excel files and insert a value in any cell declared in the code.
This code inserts the data in the workbook:
Sub InsertValueInCell()
Range("C3").Value = _
InputBox(...
- 1
1
vote
0
answers
223
views
Plotly interactive plot python: How to change text by changing the dropdown?
The line graph with the dropdown button can select the data by different district to show.
However, I would like to add the text on the left-bottom corner of the plot to show the value (input_df5), ...
- 11
1
vote
6
answers
198
views
Using MsgBox and get error msg 1004 when I select "Cancel" - Need the macro to just end normally
First I selected "Yes" to the question "Change Worksheet Name?". Then the message "Type new Worksheet Name" appears. Instead of typing in a new name and selecting "...
- 11
0
votes
1
answer
77
views
How to delete multiple sheets using input box
Just need some help. I want to delete multiple sheets using their partial name that I will enter in the input box. Is there any code that I can add multiple partial names in input box so they will be ...
0
votes
1
answer
1k
views
Replace values within a column of a table using Table Name and Column name in VBA
I have the next table
header1
header2
header3
v
x
v
x
v
x
x
x
v
v
v
x
v
x
I want to replace "x" for another value for each column, for example "true" for 1st column, "false&...
- 67
0
votes
1
answer
109
views
Powershell InputBox (selfmade) only returns "Cancel"
`In a Powershell project - small GUI with Winforms - I need a passwordbox. I wrote a test-function but cannot manage to get the correct output ... I only get "Cancel"
I get the same result ...
- 23
0
votes
1
answer
118
views
ListBox list identical after second run of Sub with different InputBox variable value
So I have a spreadsheet with a bunch of sheets that list names in the first column. On one sheet, the Input sheet, I have a command button that opens a Sub that prompts the user to perform a search of ...
- 321
-1
votes
1
answer
195
views
How to get String from input box in Ionic? I'm using Ionic framework for making application
I'm trying to get value from my alert in Ionic framework application. I made application and when i click the button, alert(prompt) which i can input string appears.
Even i type string in the ...
- 24
1
vote
1
answer
195
views
Copy and paste graph of one PowerPoint presentation to another PowerPoint presentation with inputbox
Hello :) what I want to do is to have a Master document (PowerPoint) to use as template and personalize with graphics that are in another PowerPoint presentation. The master document on the code is &...
1
vote
1
answer
886
views
How to add a prefix to a input value and pass it to the backend as well in laravel?
This my Input field:
<div class="col-md-4 form-group">
<label class="form-label fw-bold text-muted" >Em Code</label>
<div class="input-group"&...
- 1,467
0
votes
1
answer
82
views
Copy a column selected by input box to the next available column on an existing sheet
Very new to VBA and I have a workbook with both values and free text survey responses. I'm trying to cut the Free Response Text columns to their own sheet in my workbook. The columns this free text ...
2
votes
2
answers
96
views
Find from InputBox, copy row of found cell without using .Select
I have a spreadsheet with over 10000 rows. I need to search it using InputBox (UPC field, input is from a barcode scanner).
I need to copy the row of the found cell, and paste it to another sheet.
...
- 21
0
votes
2
answers
681
views
Excel VBA: Input box with control characters
I'm using an input box to retrieve QR-codes from reader.
Unfortunately, the parameters in the QR-code are separated by group separator characters (decimal ASCII code 29) and these characters are being ...
- 23
0
votes
1
answer
600
views
How do I put input from InputBox into a cell?
I have an InputBox where the user will type in the current month in the format of first three characters + Sale (e.g. JunSale).
I want to return this into a specific cell. This cell already has stuff ...
- 5
0
votes
1
answer
40
views
Reformat an inputbox value stored as integer to use in SaveAs
I am trying to use two separate inputboxes to return values to use in my file name, the formatting of the file name has to be very specific because it is an upload file.
I need the year and the month ...
- 213
-1
votes
1
answer
911
views
Setting up password using inputbox to hide/unhide excel sheet
I've recently made a MCQ test module that will help in preparing test papers with random questions from the question bank and conduct test and calculate the marks.
All of it has been coded and ...
- 3
2
votes
1
answer
637
views
How to change the value output of a autocomplete into the label output in jquery?
I'm starting to learn jQuery. But I can't find the solution to this "simple" problem?
When I choose a "label" in my autocomplete inputbox, it eventually displays the "value&...
0
votes
0
answers
1k
views
Using an input box in MS Word to insert values into a word document
I am trying to put together what I had hoped would be a simple macro that would take a string of text with 4 different values that need to change between lines, but I am having a hard time getting the ...
- 1
1
vote
1
answer
400
views
How do I loop an input box one additional time if criteria is not met?
I’m trying to create a series of input boxes that will prompt for more information before executing the rest of the code.
I’m stuck on the looping aspect.
The first input box is for a start date. ...
- 23
0
votes
1
answer
24
views
Access InputBox repeating user prompt
I have a large Access table. I have a query entitled qry_ExtractYear which I would like to have the criteria modified by the user and the the results exported. I have the code here which works but I ...
- 5
-2
votes
1
answer
1k
views
How to create a Input box with a functioning cancel button and a ability to have a default value
When using a InputBox I can add a default value for the text field. Like this:
inputbox('value Enter', 'enter a value', 'default value');
Unfortunately, the cancel button can not be used properly. ...
- 362
0
votes
1
answer
693
views
Input Box with multiple values in the same field
I have a macro created which does the following:
Asks for a value to be entered in an Input Box
Then searches for this value in all Workbooks in a specific folder
Returns (copies) specific cells from ...
- 1
0
votes
0
answers
232
views
VBA InputBox default value un-selection
I am using InputBox in Excel to get a simple yes or no answer from the user which I will later use for a formula to give extra information.
InputBox (actually 9 in succesion) is activated when clicked ...
- 33
1
vote
2
answers
4k
views
How to make input box readonly conditionally in React
How do I make an input box readonly conditionally? I have a state value I want to check and if it is empty, I want the input box prop of readonly to be added to the input box. This is my ...
- 61
1
vote
1
answer
778
views
Line break in an input box?
I wrote a batch script in which an InputBox is required, first of all this is the code line:
powershell -Command "& {Add-Type -AssemblyName Microsoft.VisualBasic; [Microsoft.VisualBasic....
user17524233
0
votes
1
answer
70
views
Set up an input box where the range will be pasted
I watched this video on YouTube and it really helped me a lot, now I have to improve that code. So in the code where is the line for pasting the values I have to set inputbox or something else, to let ...
1
vote
3
answers
758
views
Pass Input Box variable from one sub to another
I was reading a post by another where the need for a Global declaration wasn't needed.
I have a Sub asking for the user to enter a value, in another Sub I use the entered value to Call other Subs ...
- 13
0
votes
0
answers
151
views
No text sent to input box using Python
I am trying to send value to an input box but no matter what I have tried, it does not work.
I have tried the following ways with the HTML code embedded in this link:
time.sleep(3)
request_title = ...
- 17
0
votes
2
answers
425
views
running macro twice leads to blank result and keep getting running error
I am having 2 issues with my code.
First issue: I cant get it to save as the oriTitle when I am running the macro for the second time and answer with no to the question if I wanted to change the title....
- 3
0
votes
2
answers
352
views
If Statement combined with InputBox
here is what I am trying to do:
The file is supposed to save itself according to the user's input and even if there is an input at all. Meaning, if a user has not made any inputs yet, the IF-Statement ...
- 3
0
votes
4
answers
942
views
How to get inputbox parameters in vba
I have a trivial problem. I need to easily get each range parameter as a variable in msgbox. i can try to get this target using mid or left from range.adress, but the range can be variable, I have to ...
0
votes
0
answers
41
views
Ho do I copy the value from Input box and use it to search the same value in other excel?
Dim WB As Workbook
Dim URL As Variant
Dim Sh As Worksheet
Dim WB1 As Workbook
Dim i As Integer
Dim LR As Long
Dim stext As String
ThisWorkbook.Activate
Set WB = ...
user16486284