Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User enters data in popup box - its entered into desired cell
Can anyone help with a simple macro that will bring up a input box
allowing the user to enter their name which will then, on clicking OK, enter their response into a predetermined cell, say B7. Simple? Not for me! Please help --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User enters data in popup box - its entered into desired cell
ian123,
You could search Google for plenty of different ways to do this. Here's a siple one: range("B7").Value = inputbox("Enter your Name") John "ian123" wrote in message ... Can anyone help with a simple macro that will bring up a input box allowing the user to enter their name which will then, on clicking OK, enter their response into a predetermined cell, say B7. Simple? Not for me! Please help --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data entered from list automatically enters number in another cell | Excel Worksheet Functions | |||
User entry in cell creates popup | Excel Discussion (Misc queries) | |||
data enters date in next cell for several columns | Excel Worksheet Functions | |||
Selecting from drop down list enters multiple cell data | Excel Worksheet Functions | |||
If values are'nt entered in cell a popup window comes up?? | Excel Worksheet Functions |