Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default VBA Code to have User input data for cell

Afternoon Gurus!!!

I have written the following code

Rows("1:5").Select
Selection.Insert Shift:=xlDown
Range("A1").Select
ActiveCell.FormulaR1C1 = "Company Name"
With Selection.Font
.Size = 16
End With
Range("A3").Select
ActiveCell.FormulaR1C1 = "TRIAL BALANCE FOR PERIOD ENDING:"
Range("F3").Select
ActiveCell.FormulaR1C1 = "4/30/2010"
Rows("1:3").Select
Selection.Font.Bold = True
Range("F3").Select
With Selection.Font
.Size = 14
.ColorIndex = 5
End With
End Sub

In the middle of the code, where it says "ActiveCell.FormulaR1C1 =
"4/30/2010"", I want to change that to where there is an input box that
appears, and the user has to put in a value. What would the code look
like?????
--
Thanks for all of the help. It is much appreciated!!!!
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
Prompt user to input data (pop-up box) Shags Excel Discussion (Misc queries) 2 January 13th 09 06:05 AM
refilling data in same cell after user input in another cell H. Singh Excel Discussion (Misc queries) 7 April 24th 07 12:48 PM
User Data Input DRANDON Excel Worksheet Functions 0 June 30th 06 08:12 PM
Have user input converted to uppercase in same cell as input? Shannonn New Users to Excel 1 June 20th 06 03:19 AM


All times are GMT +1. The time now is 02:59 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"