.text

  1. D

    Userform Listbox Not Returning Selected Value (.Text)

    Hi all, I have a Userform with two Listboxes and two Labels on it. Both Listboxes are populated in the Initialize procedure and one item is selected in each as a default when the user launches the Userform. I would like the Label1 to show the item selected in the Listbox1 and Label2 to show...
  2. I

    Edit to working userform info

    The code supplied below is for 7 Textboxes. I have removed 2 of the Texboxes & replaced them with ComboBox1 & ComboBox2 When i now try to transfer data from userform to worksheet i see a msg telling me basicslly that i did not enter anything in the first ComboBox. How cam i add an edit to also...
  3. S

    Adding blank page in word

    i have to added blank page in word 2010 after every 3 , 6 , 9 , 12 till the end the below macro run but blank page is not inserted and the format should remain same Sub PB() Selection.HomeKey Unit:=wdStory With Selection.Find .MatchWildcards = False .ClearFormatting...
  4. S

    Save sheet1 in .csv and sheet2 in .text - vba - excel

    Hello, Is there anyone that can tell me how to save sheet1 in .csv and sheet2 in .text file in one go with VBA. Greetings, Steel010
  5. G

    Using .glow to glow text in textbox

    I'm trying to make a powerpoint from excel. In the powerpoint there will be pictures automatically (this all is working). On top of a picture I put a textbox with text. For a better look I want the text glow so the contrast will be better. I'm using next vba-code ... (in a subroutine) Set...
  6. kelly mort

    Help me adjust this code to suit my need

    I came across this code while searching the from the net . I need some explanation to what is happening so I can modify it to suit my needs. Why the number 809? Should that number be used for all other symbols ? Please help With Me.MBStake.Text = Application.Text(Range("MBStake").Value...
  7. A

    Userform filter datas by two combobox criteria.

    Private Sub ComboBox9_Change()Application.ScreenUpdating = False Dim a, i As Long, ii As Long, b(), n As Long ListBox1.Clear With ComboBox9 If .Text = "" Then Exit Sub If WorksheetFunction.CountIf(Worksheets("taxi").Range("a:a"), .Text) = 0 Then Exit Sub End If a =...
  8. A

    .Text or .Value

    I have a macro that runs and extracts data from the cells. I noticed that sometimes I have to use .Text and other times .Value. I started out with .Value but I had some problems with data that was being read so I had to use .Text. Is there a rule or best practice for using these 2? I am...
  9. S

    Importing Multiple Text Files into Excel from Multiple Folders

    Hi I am not a Macro developer so not that advanced at that stuff but I need help importing data from multiple .text files into a single excel sheet. The problem I face is as follows: 1. I have 100+ folders each with a unique name but each contains a text file with the same name which is...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top