case

  1. B

    Multiple dependant comboboxes with repeating list

    Hi, I presently have a coding that works but it is extremely long and I would like to know if there is an easier way (I am presuming yes) Present set up ComboBox1(ListProv1) -select a Province / ComboBox2(ListCity1) -select a City the list of cities will depend on the selection in Combobox1...
  2. R

    Case VBA

    Hi Guys I have the following vba codes Sub d() Range("b2") = Format(Date, "dd/mmmm/yyyy") Const mydrive = "C:" Const mydir = "Users\rakesh\Desktop\test" Dim myname As String Dim ss As String myname = Sheets("sheet1").Range("e5").Text & Format(Date, "dd-mmm-yy") & ".xls" ss = mydrive & "" &...
  3. J

    Office 365 proplus

    i have this code for template when run get error we cannot opened, and highlight this line of the code: Set oMail = Application.CreateItemFromTemplate(strTemplate) complete code: Public lstNum As Long Public Sub ChooseTemplate() Dim oMail As Outlook.MailItem Dim oContact As...
  4. H

    Creating a loop

    This is probably a simple thing for many of you, but I can't figure it out. I have an Active X Text Box which has a default size set. if the user enters more than 9 lines of data then the text box starts to increase size every time a new line of data is added. Now this code is going to get...
  5. kelly mort

    Images not switching with printing loop

    Hello again, I am yet into another trouble and I want someone pull me out: My image control is not switching its images when I use the loop to print. It maintains only the first image throughout . So if the first item has no image, then it takes that for all the others. Meanwhile when I...
  6. H

    Edit output from a measuring machine

    Hi! I have data that is output from a measuring machine. The machine outputs numerical data with a one letter descriptor of direction into each cell. For example in row one I have 0.1 H, 0.2 B, 0.1 I, 0.4 F All of the results are positive numbers with a descriptor. The descriptor tells me...
  7. J

    Fastest way to clear data

    Hi, Curious about fastest way to clear data from a range, I created following and resulting output: Sub testrun() Dim x As Long For x = 1 To 3 testtime x Next x Debug.Print "" End Sub Sub testtime(ByRef testvar As Long) Dim st As Double Dim rng As...
  8. I

    ComboBox must have a value before form submission

    Morning, I am using the code shown below but need some advice please. There is nothing to stop me pressing the CommandButton and saving blank info to the worksheet cells. It would be nice that each ComboBox MUST have a value in it BEFORE it can be sent to the worksheet,maybe in the way of an...
  9. J

    VBA solution for selecting a range of months

    The purpose is to select a month from data validation, and other cells populate future months. Then when selecting a different month those same cells change. Is there a way to capture multi months in different cells when a case is selected? Selecting Jan, D2=Feb,D3=Mar,D4=Apr Selecting Feb...
  10. tlc53

    VBA Code Hide / Unhide Rows based on selection of 2x Drop Down Lists

    Hi there, I have the below code, which is working well at hiding and unhiding rows depending on the number of investments selected from the drop down list. In additional to my current code, I was wondering if I could go a step further and hide further rows depending on the outcome of 2x drop...
  11. navic

    Remove module from multiple xlsm workbooks

    I use Excel 2013. I have dozens of workbooks in the folder. The format of all files is * .xlsm. Each workbook contains several modules. I want at once to remove/delete 'Module2' from all workbooks. In the Master workbook I have this VBa macro below. When I run it, nothing happens, there is no...
  12. B

    importing data from multiple files in the same folder to a master file

    I have this code to allow a user to select a folder, although they can only choose from a folder in the same subfolder as the active document. I have a couple requests. How can I enable the user to select any folder on their computer or authorized network? Also I would like the code to not...
  13. T

    Inspecting elements of a collection

    This code checks the version of Excel installed: Option Explicit Sub Test() Dim abc As Collection Set abc = New Collection abc.Add Module2.Version abc.Item (0) ' FAILS HERE End Sub Option Explicit Public Function Version() As Collection...
  14. C

    Updating a progress claim in excel

    I would like to figure out a way to parse through an excel sheet and replace cell values with a formula. I'm guessing this is done with a macro but I've never created macros on my own and so I am not sure how to start. In the example I want to check if cell A10 is a number in which case, D10 to...
  15. countryfan_nt

    SendKeys "{ESC}" Not working on Code

    Hello friends, Hope all is well! Strange thing, the below code works but Very slow. When I press the Esc button the code runs fast & smooth. Please help me apply the Esc command within the code please. Thank you So much in advance! Sub B_REV() Dim aSeries As Series...
  16. W

    email linking

    Hi All, I have a situation here and need help. End goal: Hyperlink or button with Concat emails that can be copy pasted in outlook "to" field Prob: Column A = Name of members Column B = Email IDs of members Column C = Title: Use case 1 --> People who should receive email for use case 1 have...
  17. N

    Nested select case

    This was working fine but I added an additional level of case select statements and now I get a 'Case without select' on the 2nd case of the top level Select (in code comments) Thanks for your suggestions. Select Case Cells(row, "AH").Value Case "Y" 'Secondary...
  18. R

    Compile error: Case Else outside Select Case

    I've looked up what the title of this post means, but (pardon the pun) that's not the Case. I must have done something else wrong, either syntactically or logically, but I can't see it. The following Sub works fine until I try to insert the commented lines. Private Sub TextBox1_Change()...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top