Hi Jyothi, Here is the link to find more details about ComboBox. Combo Box Regards
Hi, I would like to know more details about your query.
There are a few activities that you can't perform on Microsoft Excel worksheets or workbooks through the Microsoft Excel installable...
[img alt_text='' description='']http://vbaf1.com/q/wp-content/uploads/2018/05/listing.jpg[/img]
[img alt_text='' description='']http://vbaf1.com/q/wp-content/uploads/2018/05/screen.png[/img]
Dear sir Still have one more writing problem, it is taken only first rown of the invoice, second row is...
Thanks for the help. I have resolved the above isued. by giving following "Scrap items - "& VLOOKUP(B11,INDIRECT(SELECT&"!B:C"),2,0) I used...
[img alt_text='' description='']http://vbaf1.com/q/wp-content/uploads/2018/05/Untitled.jpg[/img]
You are awesome, it works perfectly. Only issue is that the Date format in the Output Sheet is coming in as “Custom” instead of “Date” because of which this needs to be modified manually.
Hi Yaseer here is the link https://we.tl/8R9kqh99SX
Unable to attach the excel sheet, do I need to subscribe to something before I do it? I don’t mind doing that as well. Please let me know
Valli sir-when I run this macro nothing seems to be happening, am I missing something. I would want the macro to search for rows with Workday and wherever there are multiple states, copy them in separate rows either on Sheet 1 or Sheet 2 as separate entries.
Can I populate different values in this template for multiple users. To explain this further if I create a datasheet and have multiple sheets to be created using the data. Something like a mail merge in excel, how do i modify this code
Thank you for your help as also, much appreciated.
Thank you tried this, somehow not working. I am sure I am missing something on execution? My question is should i insert this code in the USERFORM by double clicking.
Thank you, this works perfectly fine.
I need help in having each text file with a unique name. How do I modify my VB code. It will be a great help
Need help in fixing this macro. I would like to pull historical fx rates from this URL and save it in excel:-
‘ CrawlWeb Macro
‘ With ActiveSheet.QueryTables.Add(Connection:= “URL;http://x-rates.com/historical/?from=USD&amount=1&date=Name”,Destination:=Range(“$A$1”)).CommandType = 0
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingNone
.WebTables = “2”
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False