Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can an input box do this
Can a macro button activate a cell, then have an an input box pop up that
asks a user to enter their name, and upon doing so & clicking OK place the name in the activaed cell? I'm self taught at Visual Basics & can't figure how to do this. Am I misunderstanding input boxes - or can an input box do this, and if so, how? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can an input box do this
hi
vb101. but which cell to activate????? Sub addname() Dim n As String Range("B1").Activate n = InputBox("what is your name?") ActiveCell.Value = n End Sub regards FSt1 "Munchkin" wrote: Can a macro button activate a cell, then have an an input box pop up that asks a user to enter their name, and upon doing so & clicking OK place the name in the activaed cell? I'm self taught at Visual Basics & can't figure how to do this. Am I misunderstanding input boxes - or can an input box do this, and if so, how? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can an input box do this
You don't even need to activate the cell first. You can just plop the value
that the user typed right into the cell: Option Explicit Sub testme() Dim myCell As Range Dim myStr As String Set myCell = ActiveSheet.Range("C9") myStr = InputBox(Prompt:="Please enter your name") If Trim(myStr) = "" Then Exit Sub 'user hit cancel End If myCell.Value = myStr End Sub If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Munchkin wrote: Can a macro button activate a cell, then have an an input box pop up that asks a user to enter their name, and upon doing so & clicking OK place the name in the activaed cell? I'm self taught at Visual Basics & can't figure how to do this. Am I misunderstanding input boxes - or can an input box do this, and if so, how? -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can an input box do this
As with all programming, what code you use depends on how you want the
program to present itself to the user. The code for your request could be as simple as this (where you would change the B1 cell reference to the address of the cell you wanted to put the name in)... Sub AddName() Range("B1").Value = InputBox("Enter your name.") End Sub However, this will blank out B1 if the user hits enter without typing anything or if he/she clicks the Cancel button. Perhaps this would be more robust... Sub AddName() Dim EnteredName As String EnteredName = InputBox("Enter your name.") If Len(EnteredName) = 0 Then MsgBox "You didn't enter anything!" Else Range("B1").Value = EnteredName End If End Sub Of course, you can make your code even more intelligent than this.. again, it all depends on how you want it to present itself. -- Rick (MVP - Excel) "Munchkin" wrote in message ... Can a macro button activate a cell, then have an an input box pop up that asks a user to enter their name, and upon doing so & clicking OK place the name in the activaed cell? I'm self taught at Visual Basics & can't figure how to do this. Am I misunderstanding input boxes - or can an input box do this, and if so, how? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
=SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF | Excel Worksheet Functions | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming |