Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax
Hi All
I am having a syntax problem. I have always used Input Boxes for my data, but have finally bitten the bullet and started creating UserForms. However, my current Command_Click doesn't want to do as it is told. I want to copy the information in TextBox1.Text to Worksheets("draw").Range("M5") when I click the OK button....but the damn thing won't. I have the Walkenbach book which explains User forms but can't find anything to help. Regards Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax
Worksheets("draw").Range("M5") = Me.TextBox1.Text -----Original Message----- Hi All I am having a syntax problem. I have always used Input Boxes for my data, but have finally bitten the bullet and started creating UserForms. However, my current Command_Click doesn't want to do as it is told. I want to copy the information in TextBox1.Text to Worksheets("draw").Range("M5") when I click the OK button....but the damn thing won't. I have the Walkenbach book which explains User forms but can't find anything to help. Regards Michael . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF, THEN SYNTAX | Excel Worksheet Functions | |||
VB Syntax | Excel Discussion (Misc queries) | |||
The NOW() syntax | Excel Discussion (Misc queries) | |||
VBA syntax | Excel Discussion (Misc queries) | |||
If then syntax | Excel Worksheet Functions |