A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Programming Forum Tools Search this Forum Feed Icon
  Rating Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Copying/cloning an object by Walter Briscoe
I do a lot of scraping information into Excel 2003 from the Internet via Internet Explorer (IE). I would like to do overlapped IO. Grab the first piece of...
July 5th 16 05:53 PM
by GS[_6_] Go to last post
3 356
Error in VB Editor Coding by Tim Childs[_10_]
Hi I have used the code below to close the extra VB windows that end up being open when using the VBA editor. Sub CloseVBEWindows() Dim W As...
(Multi-page thread 1 2)
July 4th 16 02:20 PM
by GS[_6_] Go to last post
19 565
Comments do not appear by [email protected]
My application consists of a UserForm menu and several report sheet-tabs. The problem is when the selected report opens, and the user hovers their mouse over...
June 30th 16 06:28 PM
by GS[_6_] Go to last post
1 266
Active x control by Fawn Lagimodiere[_2_]
Hi. I have a combo box with active x control, however users are able to delete. Users are able to delete field from the combo box but I would like to know...
June 28th 16 05:43 PM
by GS[_6_] Go to last post
1 328
reverse of CHR function by c1802362[_2_]
Good morning all, Returning a character using the CHR function is simple: MsgBox Chr(65) returns 'A' However, is there a reverse CHR function that...
2 317
Writing formulae from array to range by Walter Briscoe
I started to compose this as a problem. I now have a solution, I would value an explanation. I have a second problem at the end. I have a sub which is worth...
June 24th 16 03:31 AM
by GS[_6_] Go to last post
2 293
VBA to send Outlook email - stuck in Outbox by Phrank
Hi. At work, employees have an individual report in a folder that they are supposed to do each day. When they are done, there is a signoff sheet in their...
June 23rd 16 04:42 AM
by Phrank Go to last post
9 613
Clear Contents and Checkboxes Button by chrisparker3268
Hello, I am trying to create a button in that will clear contents of E5:E8 and and also clear all checkboxes (located in D5:D8) on the sheet. I have the codes...
June 21st 16 05:59 PM
by Claus Busch Go to last post
1 356
VBA to read save messages on an Excel sheet by Juan López
Hi, I've been trying to write a scrip on VBA for outlook, I need that for each new email that contains a spceficid prhase in the subject, the email should be...
June 21st 16 03:58 PM
by Claus Busch Go to last post
2 360
Pivot wrt active sheet & current region by ANG
Range("A1").Select Sheets.Add ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "wr!R1C1:R638C31",...
June 21st 16 06:28 AM
by Claus Busch Go to last post
1 305
HLookup/Needing Formula Question by Munster
Sheet 1 A B C D 1 Location Item Qty. Lot# 2 001a Apples 23 5998 3 002a ...
June 21st 16 05:53 AM
by Claus Busch Go to last post
3 355
using formula - extract text separated by 2 spaces by ANG
Would be great if someone could give me a formula which would separate text between 2 spaces e.g 10001031 BISCUIT TUC NATURE 100G Ea BEACH SHOP -6 ...
(Multi-page thread 1 2 3)
June 19th 16 08:57 PM
by ANG Go to last post
21 913
Putting Focus into Textbox by jlclyde[_2_]
I have a userform that I am using a barcode scanner to populate a text box. When the form loads the cursor is in the barcode textbox. On change event it does...
(Multi-page thread 1 2)
June 18th 16 02:01 AM
by Mike S[_5_] Go to last post
10 627
.SpecialCells(xlCellTypeBlanks).Delete without going to the sheet by L. Howard
The whole macro is below, which does what I want. It is in a standard module and will be run from any of about 8 to 10 different worksheets. This snippet...
June 17th 16 05:20 PM
by L. Howard Go to last post
9 417
Checkbox Quandry by [email protected]
I have a spreadsheet with a number of non-contiguous checkboxes (forms control) in column A. Section headings break up the sequence. In column B, there is a...
(Multi-page thread 1 2)
13 711
Temporarily Suppressing the Printing of Page Footers by Tim Childs[_10_]
Hi I am creating a formal document (annual accounts) in Excel and while working on the Excel file want the page footers to print but need to be able to...
June 11th 16 07:59 PM
by GS[_6_] Go to last post
3 817
Key press alternative for Ctrl+Break by BlueDice
Greetings everyone For keyboards without the Break key I know that there are a number of alternatives depending upon which pc you look at. I am contemplating...
June 10th 16 11:13 PM
by GS[_6_] Go to last post
3 583
Excel Add-ins for 2010 by [email protected]
How do I download the Power Query add-in for my 2010 versin of excel. I've gone to the Microsoft Download Centre and clicked on DOWNLOAD - 32 BIT, then next...
1 508
Convert Number to Words (Indian Format) by Tilak Minocha
How to convert numbers into words in Microsoft excel for example to convert 1,23,123.56 into "Rupees one lac twenty thre thousand one hundred twenty three and...
June 10th 16 01:06 AM
by Auric__ Go to last post
5 670
My code stops working by [email protected]
I have the follwoing code in Sheet1. Using it, I can hide og show specific sheets by putting x'es in cells A1 to H1. It woeks nicely, but if I rename just one...
June 9th 16 07:34 PM
by GS[_6_] Go to last post
7 649
Post New Thread

Display Options
Showing threads 141 to 160 of 174022
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.