Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Victor
 
Posts: n/a
Default Creating UserForms

Can anyone offer a bit of information on how to create a form that places
data valuses in a certain cell. I have download cortexure samples programs
and need help figuring them out.
  #2   Report Post  
FSt1
 
Posts: n/a
Default

hi,
Create a form with a text box(with id lable) and and command buton. in the
text box property sheet, gve the text box the name txtInput1(or a name you
will remember easily)
code for the command button.

sub CmdBut_click()
dim rng as range
set rng = Range("A1")
rng = me.txtInput1
me.txtInput1.setfocus
end sub

with this code whatever you input into the text box will appear in cell A1.
you can add more text boxes and change the destination cell.
good luck
FSt1

"Victor" wrote:

Can anyone offer a bit of information on how to create a form that places
data valuses in a certain cell. I have download cortexure samples programs
and need help figuring them out.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating custom list with a comma in it barnabel Excel Discussion (Misc queries) 6 January 10th 06 06:14 AM
Open Userforms from a Dropdown list skid812pb Excel Discussion (Misc queries) 0 May 23rd 05 11:28 PM
Creating a formula using absolute referencing - I think!! Victoria Excel Worksheet Functions 4 February 26th 05 08:13 PM
Eliminate creating list that returns blank cells Marc Todd Excel Worksheet Functions 1 January 26th 05 09:58 PM
creating an x,y chart smintey Charts and Charting in Excel 2 December 16th 04 11:11 PM


All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"