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
Find and Replace Q by seanryanie@yahoo.co.uk
I took the code below from SpreedsheetGuru, but want to tweak it for my specific needs and I am a little lost Code below Finds & Replaces from a Table values...
July 9th 16 01:46 PM
by seanryanie@yahoo.co.uk Go to last post
2 250
Angry
Programing to save who and when someone update the file by S@bugomes
I'm trying to programing the file to save in the column "R" and "S" the timing and user who updated the file, but this only works for updating in the first...
July 8th 16 06:49 PM
by GS[_6_] Go to last post
4 244
Multiple selections simultaneously from a data validated dropdown list by Phrank
Hi, I've got my spreadsheet set where users are able to select multiple values from a data validated dropdown list one at a time. All values selected show up...
July 8th 16 04:16 PM
by GS[_6_] Go to last post
4 274
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 301
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 476
Comments do not appear by robflott2@gmail.com
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 224
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 282
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...
June 25th 16 03:19 AM
by c1802362@gmail.com Go to last post
2 265
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 243
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 541
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 302
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 293
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 257
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 299
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 754
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 536
.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 352
Checkbox Quandry by jamasm2010@gmail.com
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)
June 17th 16 04:57 PM
by jamasm2010@gmail.com Go to last post
13 617
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 690
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 498
Post New Thread


Display Options
Showing threads 121 to 140 of 174006
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 06:46 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.