Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
object required
i copied this from a book. i run the macro and it says object required. what's up? Private Sub cmdinsertheading_click() Cells(1, "d").Value = txtheading.Text Cells(1, "d").Select With Selection .Font.Bold = True .Font.Name = "arial" .Font.Size = 72 .Font.Color = RGB(0, 0, 255) .Columns.AutoFit .Interior.Color = RGB(0, 255, 255) .Borders.Weight = xlThick .Borders.Color = RGB(0, 0, 255) End With txtheading.Activate End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
object required
Cells(1, "d").Value = txtheading.Text
You are trying to put something in cell D1 that has not been defined in this procedure. txtheading appears to be a variable, but unless it is made a global variable its value will not be picked up by a procedure that is private. The options are to make it a global variable or to define it within this procedure. "kyle" wrote in message ... i copied this from a book. i run the macro and it says object required. what's up? Private Sub cmdinsertheading_click() Cells(1, "d").Value = txtheading.Text Cells(1, "d").Select With Selection .Font.Bold = True .Font.Name = "arial" .Font.Size = 72 .Font.Color = RGB(0, 0, 255) .Columns.AutoFit .Interior.Color = RGB(0, 255, 255) .Borders.Weight = xlThick .Borders.Color = RGB(0, 0, 255) End With txtheading.Activate End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
object required
The term txtheading is undefined; this produces the run-time error you
describe. From the original code, I would guess that the text heading you are manipulating in code is supposed to come from the contents of a cell somewhere in the worksheet. Try this statement immediately after the procedures opening statement: Set txtheading = Range("M17") substitute the cell address that contains the heading text for M17 ------ Jay "kyle" wrote: i copied this from a book. i run the macro and it says object required. what's up? Private Sub cmdinsertheading_click() Cells(1, "d").Value = txtheading.Text Cells(1, "d").Select With Selection .Font.Bold = True .Font.Name = "arial" .Font.Size = 72 .Font.Color = RGB(0, 0, 255) .Columns.AutoFit .Interior.Color = RGB(0, 255, 255) .Borders.Weight = xlThick .Borders.Color = RGB(0, 0, 255) End With txtheading.Activate End Sub |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
object required
hi
what is txtheading.text? sound like a textbox from a form. also txtheading.activate......sounds like it's trying to activate the form/textbox? anyway txtheading is the object that vb needs/can't identfy. regards FSt1 "kyle" wrote: i copied this from a book. i run the macro and it says object required. what's up? Private Sub cmdinsertheading_click() Cells(1, "d").Value = txtheading.Text Cells(1, "d").Select With Selection .Font.Bold = True .Font.Name = "arial" .Font.Size = 72 .Font.Color = RGB(0, 0, 255) .Columns.AutoFit .Interior.Color = RGB(0, 255, 255) .Borders.Weight = xlThick .Borders.Color = RGB(0, 0, 255) End With txtheading.Activate End Sub |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
object required
Also, the use of the Cells property requires a qualified sheet reference if
the code is not in a sheet code module. It is a good practice to always qualify cells property to be sure the range object on the correct sheet is acted upon. \ "kyle" wrote in message ... i copied this from a book. i run the macro and it says object required. what's up? Private Sub cmdinsertheading_click() Cells(1, "d").Value = txtheading.Text Cells(1, "d").Select With Selection .Font.Bold = True .Font.Name = "arial" .Font.Size = 72 .Font.Color = RGB(0, 0, 255) .Columns.AutoFit .Interior.Color = RGB(0, 255, 255) .Borders.Weight = xlThick .Borders.Color = RGB(0, 0, 255) End With txtheading.Activate End Sub |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
object required
something still isn't right. i put this in the code Set txtheading = Range("m17") and what i type in m17 will appear in column d for a split second then dissappear "JLGWhiz" wrote: Also, the use of the Cells property requires a qualified sheet reference if the code is not in a sheet code module. It is a good practice to always qualify cells property to be sure the range object on the correct sheet is acted upon. \ "kyle" wrote in message ... i copied this from a book. i run the macro and it says object required. what's up? Private Sub cmdinsertheading_click() Cells(1, "d").Value = txtheading.Text Cells(1, "d").Select With Selection .Font.Bold = True .Font.Name = "arial" .Font.Size = 72 .Font.Color = RGB(0, 0, 255) .Columns.AutoFit .Interior.Color = RGB(0, 255, 255) .Borders.Weight = xlThick .Borders.Color = RGB(0, 0, 255) End With txtheading.Activate End Sub . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
object required
Kyle -
After the procedure sets the value in D1, the combination of three things scrolls the window and the entry seems to disappear (but it's still there). 1. ".Font.Size =72" makes the entry very large. 2. ".Columns.Autofit" widens the column to fit the large font. 3. "txtheading.Activate" forces cell D1 to scroll to the left (where you can't see it). So, rem out the statement txtheading.activate at the end and the procedure should work, i.e., procede it with a single qoute ('txtheading. Activate). ----- Jay "kyle" wrote: something still isn't right. i put this in the code Set txtheading = Range("m17") and what i type in m17 will appear in column d for a split second then dissappear "JLGWhiz" wrote: Also, the use of the Cells property requires a qualified sheet reference if the code is not in a sheet code module. It is a good practice to always qualify cells property to be sure the range object on the correct sheet is acted upon. \ "kyle" wrote in message ... i copied this from a book. i run the macro and it says object required. what's up? Private Sub cmdinsertheading_click() Cells(1, "d").Value = txtheading.Text Cells(1, "d").Select With Selection .Font.Bold = True .Font.Name = "arial" .Font.Size = 72 .Font.Color = RGB(0, 0, 255) .Columns.AutoFit .Interior.Color = RGB(0, 255, 255) .Borders.Weight = xlThick .Borders.Color = RGB(0, 0, 255) End With txtheading.Activate End Sub . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Object Required | Excel Programming | |||
Object Required | Excel Programming | |||
Object Required | Excel Programming | |||
Object Required | Excel Programming |