.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...

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...

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...

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

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...

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...

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 =...

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...

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...