Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting TextBox values
In the code below I am attempting to select all of my worksheets, then
select cell A1301 and past the data from textboxes into cell A1301 and B1301 of all the Worksheets. What happens is that all of the worksheets are selected and cell A1301 is selected on all the worksheets but the data is only placed on the 1st worksheet (June - August). So two questions: 1. Is there a shorter way to select all worksheets? 2. How can I paste the TextBox values to all of the worksheets? Dim rng Set rng = Cells(ActiveCell.Row, 1) Sheets(Array("June - August", "September - November", "December - February", _ "March - May", "Annual")).Select Sheets("June - August").Activate Range("A1301").Select rng(1, 1).Value = TextBox3.Text rng(1, 2).Value = TextBox5.Text |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cutting and Pasting Cells into a shape or textbox | Excel Discussion (Misc queries) | |||
pasting textbox value to active cell | Excel Discussion (Misc queries) | |||
Pasting to Cells from TextBox User Control | Excel Programming | |||
How do I add TextBox.values? | Excel Programming | |||
How do I add TextBox.values? | Excel Discussion (Misc queries) |