Forum Discussion
Data Validation Input Message
Ok so here's my question. I've created an Excel call log for my Non-Profit Organization. Date/Time/Name/Phone/Type of call/Detail of call/Resolution of call (color codes) Now I'm wondering abou...
I think what you saying is rather than typing you want to have a list of option to select from .if it is kindly follow the link i think it will help. https://www.youtube.com/watch?v=SlWIgMFpsPg&t=22s
let me know if you have more questions
let me know if you have more questions
No I already have a drop down list for the type of call I have, I got like 6 categories in a dropdown. What I meant is my cell where I explain what the person wants, the details I write about the person.
Every single time I want to enter this into a input text in Data Validation I must go up, click the icon and go back down. Wouldn't be easier to have the possibility of way of putting a button directly into my cell where all I have to do is click that button and it would open up right there Data Validation/Input message and I only have to type what I need?
It's also annoying that you can no longer format Input, the police is way too small which makes it hard to read and we cannot edit the background too.
Every single time I want to enter this into a input text in Data Validation I must go up, click the icon and go back down. Wouldn't be easier to have the possibility of way of putting a button directly into my cell where all I have to do is click that button and it would open up right there Data Validation/Input message and I only have to type what I need?
It's also annoying that you can no longer format Input, the police is way too small which makes it hard to read and we cannot edit the background too.
- So I tried to make some research and i was able to get some work arounds try this if it works.
Step-by-Step Solution:
1. Use VBA to Create a Right-Click Menu Option
You can add a right-click menu option to quickly trigger an input box.
Open Excel and press Alt + F11 to open the VBA editor.
In the Project Explorer, find your workbook. Right-click on ThisWorkbook, and select View Code.
Paste the following VBA code:
Private Sub Workbook_Open()
' Add a custom option to the right-click menu
Application.CommandBars("Cell").Reset
With Application.CommandBars("Cell").Controls.Add(Type:=msoControlButton, Before:=1)
.Caption = "Enter Details"
.OnAction = "ShowInputBox"
End With
End Sub
Sub ShowInputBox()
Dim response As String
response = InputBox("Enter details about the person:")
' If not canceled, place the response in the active cell
If response <> "" Then
ActiveCell.Value = response
End If
End Sub
Close the VBA editor (Alt + Q).
Save and close the workbook. Then, reopen it to trigger the Workbook_Open event.
2. Use the New "Enter Details" Option
Right-click on any cell, and you will see a new option called "Enter Details" in the context menu.
Clicking it will open an input box, where you can type your details directly into the selected cell without manually going through the Data Validation settings.
