| 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 | |||
![ian123[_30_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
