$$Excel-Macros$$ How to match a combobox result with an textbox

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

Re: $$Excel-Macros$$ Sorting Data

added, and what it should look like when the sort is complete? thanks. Paul From: Tommy jntwh...@verizon.net To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Wed, December 16, 2009 10:53:17 AM Subject: $$Excel-Macros$$ Sorting Data I have

$$Excel-Macros$$ Sorting Data

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

$$Excel-Macros$$ convert lotus file to excel

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

$$Excel-Macros$$ Patron List

? 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

$$Excel-Macros$$ cell selection

to be 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

$$Excel-Macros$$ InputBox

. Tommy Sub New_Name() Name = Application.InputBox(Enter New Name) Copy.Name Range(A1).Select ActiveSheet.Paste End Sub --~--~-~--~~~---~--~~ -- Some important links for excel users: 1

$$Excel-Macros$$ Strange Macro behavior

for it? 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, SkipBlanks _ :=False, Transpose:=True 'Sort sales

$$Excel-Macros$$ Find Clear

. 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, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection

$$Excel-Macros$$ 2002 - 2007 compatibility

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 downloads

$$Excel-Macros$$ Screen fluttering during macro run time

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

$$Excel-Macros$$ Hidden sheets

' 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).Select End Sub The error comes up on line 2 having to do

$$Excel-Macros$$ Re: Excel 2002 Forms toolbar

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 aind...@gmail.com wrote: How did you

$$Excel-Macros$$ Drop-down Box display

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