Hi,
i am stuck on my project, an i am still a noob on VBA :P
i have a userform with 4 textboxes and a combobox with 5 options that link
each one to 5 sheets.
Sheets (A,B,C,D and E)
Combobox with options ( 1,2,3,4 and 5)
textboxes (textnorth, textsouth,textwest and texteast)
when i choose opti
d row 7 stays the same.
> What happens to the "extra" data?
>
> can you give an example of starting values,
> information added,
> and what it should look like when the sort is complete?
>
> thanks.
>
> Paul
>
>
> From:
I have a rectangular array, A1 through D6 for example, of contiguous
cells where each cell contains a word. Additional information is
contained in column A, beginning at row 7 and extending downward for
some number of cells, Periodically, Information is added to the top
row of the array portion of
I am using an old version of Lotus (.wk4). I would like to convert
all of my files (Many!) to Excel. What do you recommend? Thanks.
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Te
?
Tommy
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn
selected. Is there a neat way to do this?
Tommy
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http
ons appreciated.
Tommy
Sub New_Name()
Name = Application.InputBox("Enter New Name")
Copy.Name
Range("A1").Select
ActiveSheet.Paste
End Sub
--~--~-~--~~~---~--~~
--
Some
? Any suggestions?
Tommy
Sub Refresh()
Sheets("Input_T1").Select
Range("CO$458:GX$458").Select
Selection.Copy
Sheets("Reports_T1").Select
Range("M16").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipB
running and generates an error. what do i have
to do to correct that situation. below is the macro,
Sub Find_zz()
'
' Find_zz Macro
' Macro recorded 9/30/2009 by Tommy
'
'
Columns("B:B").Select
Selection.Find(What:="zz", After:=ActiveCell
o make the conversion. what must iI do to accomplish the task?
Tommy
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins do
I have a rather long macro, which when running causes distractful
fluttering of the screen, is there a way to either blank out or freeze
the screen during that time period?
Any help appreciated.
Tommy
Data Macro
' Macro recorded 8/26/2009 by Tommy
'
' Keyboard Shortcut: Ctrl+m
'
Selection.Copy
Sheets("Sheet3").Select
Range("A1").Select
ActiveSheet.Paste
Sheets("Sheet2").Select
Application.CutCopyMode = False
Range("B1&quo
I was building and didn't realize that what I wanted was was
called a "list box", so now I am in business.
I appreciate your effort in helping me, thanks verry much.
Tommy
http://www.bettersolutions.com/excel/EVZ193/QB215612321.htm
On Aug 24, 12:25 am, Aindril De wrote:
&g
SOLVED
On Aug 21, 10:58 am, Tommy wrote:
> When I bring up the Forms toolbar there are some controls that are
> grayed out, specifically the Dropdown List and some others. Can anyone
> shed any light on this. I am trying to construct a form and the
> Dropdown List control would be
I would like to be able to clear, or return to a desired state such as
“Enter xxx” the window of a drop-down box in preperation for making a
new selection.. Is this possible? What statement(s) might I use?
Any help would be welcom.
Tommy
When I bring up the Forms toolbar there are some controls that are
grayed out, specifically the Dropdown List and some others. Can anyone
shed any light on this. I am trying to construct a form and the
Dropdown List control would be needed. Any help would be greatly
appreciated.
Tommy
16 matches
Mail list logo
