Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form
Is there a way to set up a user form, or something similar, so that when I
click a button, it will bring up a place for a person to type small bits of information. When they are done and submit the info, it will go to a specific cell in the worksheet? For example, I want to add a City to a list. I click the add city button. Type in the city and click OK. The city will then be added to a list? Any help or ideas is always appreciated. Thanks, Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form
Just use an inputbox
Dim rng as Range set rng = Cells(rows.count,"F").End(xlup)(2) rng.Value = InputBox("Enter New City Name") -- Regards, Tom Ogilvy "Steve" wrote in message ... Is there a way to set up a user form, or something similar, so that when I click a button, it will bring up a place for a person to type small bits of information. When they are done and submit the info, it will go to a specific cell in the worksheet? For example, I want to add a City to a list. I click the add city button. Type in the city and click OK. The city will then be added to a list? Any help or ideas is always appreciated. Thanks, Steve |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form
Scratch that. I have decided to take a different route.
Steve "Steve" wrote: Is there a way to set up a user form, or something similar, so that when I click a button, it will bring up a place for a person to type small bits of information. When they are done and submit the info, it will go to a specific cell in the worksheet? For example, I want to add a City to a list. I click the add city button. Type in the city and click OK. The city will then be added to a list? Any help or ideas is always appreciated. Thanks, Steve |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form
slight addition ....
Dim rng as Range set rng = Cells(rows.count,"F").End(xlup)(2) rng.Value = StrConv(InputBox("Enter New City Name"),vbProperCase) -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Tom Ogilvy" wrote in message ... Just use an inputbox Dim rng as Range set rng = Cells(rows.count,"F").End(xlup)(2) rng.Value = InputBox("Enter New City Name") -- Regards, Tom Ogilvy "Steve" wrote in message ... Is there a way to set up a user form, or something similar, so that when I click a button, it will bring up a place for a person to type small bits of information. When they are done and submit the info, it will go to a specific cell in the worksheet? For example, I want to add a City to a list. I click the add city button. Type in the city and click OK. The city will then be added to a list? Any help or ideas is always appreciated. Thanks, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
user form | Excel Discussion (Misc queries) | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form | Excel Programming |