Search results

Good day, I am looking to add some code to the following function provided, somewhere online don't quite remember, but the main idea is there. The following function will make my comboboxes to search for the Letter that I will manually insert in my combobox. I need to have the following...

I have the code to restric the dates if they fall on a weekend in a Userform but what about on an activecell? I have the following code in my Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("I5:I20")) Is Nothing Then Application.EnableEvents = False...

Good day, I’ve been on this for a couple of days. I can figure out how I would take this code and rule out the weekend date. I have a userform that checks for ElseIf IsEmpty, then I would like to add the following but don’t know how I would puzzle them together: ElseIf Cells(ActiveCell.row...

Good day, I am working on enhancing my code. I need to incorporate the following. I have information in my Wb1 in Sheet1 with Column A:Z. I have data each day to replace in my Wb1. At the end of the month I need to send this info to a workbook (wb2) in the same worksheet (Sheet1) by clicking...

Good day, I have a listbox on my sheet that grabs the information from another sheet. I need, when I click a selection, to populate the information based on the range value from this other sheet and not the single selection. I mean I could do it by doing my Listbox a multiple view but that...

Good day, How would I change the EntireRow.Insert to only insert a new row from Column A to Column D. Explanation: I have to have restriction to a range (Column A to column D) as I will have more code in my Column F and up. I have code running exactly what I need but I need to change the...

Good day, I have been looking everywhere for the following code or if there is any. I have multiple Userforms...all that will all have multiple textboxes. In each Userform there will be around 3 Textboxes that will need control vs. a DatePicker. Another Userform that will need...

Good day, I am having trouble with a code that I have been trying to accomplish. I am as my name, noob. :) I have a report sheet that I have completed and now I would be missing a final code to make it a masterpiece. Like I said, it is a report sheet with steps. Therefore...

I have a “DeleteAfterRun” codes that will prompt a first time user to add his personal “UserID”. How do I record or get a find and replace code that will look in my VBE in all the Workbook either the Sheets, Modules and the Userforms to replace a specific “Text” and replace it by the one that...

Good day everyone, this is a little complicated. I have a workbook that has a find and match code. Works well and like a charm. Problem is with the following code: retenderletter = InputBox("What is the re-tender letter", "Re-Tender") If retenderletter <> "&#34...

Good day everyone, I know there is a VBA for TextBox (OnlyNumbers) but is there a VB code that will do the same thing but for cells... Example: Code Private Sub OnlyNumbers() If TypeName(Me.ActiveControl) = "TextBox" Then With Me.ActiveControl If Not IsNumeric(.Value) And .Value...

I have a UserForm with Testboxes in it and I have the code to make this work perfect. I need an addon to this code but am lost (Section of the code...where to add it and how) In my UserForm I have a CommandButton1 that would take all information inserted and paste it to the next available row...

Good day, I am looking for some help with listboxs and msgboxs. I have 2 sheets in a workbook. One is the selection to view information and sheet2 is the information to be populated. In my sheet1 I have a command button that when I click it brings up userform (listbox) with selection from my...

Fill Series – Offset – VBA Excel 2007 help Hope everyone had wonderful holidays. I would need help and expert advice on a problem I cannot seem to get pass. I have a sample of my workbook at excelforum.com but right now I can’t seem to get in. Kind of difficult to explain when you don’t have...

Good morning to all, I was just wondering if this is even possible to do. I am looking for a method to have a mouse over text box to view extra information. I have an Excel Calendar (by year) with events. Same as the template that is offered by Microsoft. I was wondering if it would be...

I am trying to find out, almost in every site, how to do the following. This code is inserted in my Sheet4: <br /> If Target.Count > 1 Then Exit Sub<br /> If Not Intersect(Target, Range("B5:B10000")) Is Nothing Then<br /> Application.EnableEvents =...

I have some code running in my main Workbook. In my last sheet, called "Archives" is information that is dead, meaning, its information that will not be used but necessary. I would love to modify my transfer vb code that I have right now to open a new workbook that I have created called...

Good morning everyone, I am trying to figure out a code that I have but to re-arrange for another column. I need, when the user selects a criteria in column X:X to add a row bellow. That I already have. I need it to also grab the information from another cell and add the information with a...

I need help in tranferring information in an existing code from one workbook to another. Is this possible? Here is my code but I need to change it in order to transfer the information on another Workbook. If LCase(Target.Value) = "cancelled" Then Range(Cells(Target.Row, 1)...

Can this be done even if the Excel spreadsheet is closed? First off, this code is unfinished but functional when you hit the macro... Sub Mail_small_Text_Outlook() 'Working in Office 2000-2010 Dim OutApp As Object Dim OutMail As Object Dim strbody As String Set OutApp =...

Good evening everyone, I am relatively new to macros and Coding with Excel. I started to construct a Report file based on an old template we use in Lotus Pro. Sorry but that system did not cut it for me. So here I am going from Forum to Forum looking for help on missing codes that I cannot...