Snippets home page
 
 
register
 
 
computer

How do you write value to a cell in excel VBA?

I need help with Excel VBA.

asked by CarolMowthorpe (44)

You have 50 words left!
 
 
related questions

How do you load data into excel sheet cells from a file using VBA?

How do you make a new line character in a Microsoft Excel cell?

What is the process of adding a vba dummy sheet?

How do I run an Excel formula in VBA?

How do you create a list from an array in excel vba?

How do you create a toolbar in Excel VBA?

What should I know about VBA and range?

Tags:  computer  how to  software

answers

Open the VBA Editor in Excel (Alt + F11) and use the following code: Option Explicit Sub write_to_cell() Range("a1"). value=3 End Sub

reply
posted by tur2 (21)
6 votes

Invoke the Range object, like this: xlsheet. Range("A1"). Value = 34, where "A1" should be your cell ID and 34 the value you wish to write.

5 votes

In VBA editor: Sheets("TAB NAME"). Range("cell name"). Value = VALUE Replace CAPITALIZED WORDS with requested information; if your value is text, use "" around the text.

reply
posted by Joe31 (13)
3 votes

you can do this, $16. 00 then if you have some value to add, then you do this next type the second value into the next after the $16. 00.

reply
posted by Tina41 (67)
3 votes

To write value to a cell in excel VBA use the VB statement Range ("cell Address"). value= value. For example Range ( "A1" ). Value = 500. You can use the Range object in VBA to set the value of a named cell, just like any other cell. Range("A1"). Value = Inputbox("Enter the number? ) where A1 is the cell address

reply
posted by Prasad (13)
0 votes

Report a post on this page as inappropriate
 If you have questions about user content, read our liability disclaimer

  
   
Add your own answer in 50 words or less! Add your comment in 50 words or less!

copyright © 2008
conjecture corporation

FAQ About Us Contact Us Terms & Conditions Privacy Policy