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
Worksheet_Calculate by L. Howard
Range("B8:B37")) are formulas returning strings such as "Cash" or Equities", as two examples, then data is copied to a certain sheet for that string. There...
August 7th 16 04:11 PM
by L. Howard Go to last post
6 344
Get data for matching headers thru macro by [email protected]
Hi, My name is Praveen, I am working on huge data import and need support on macro. I have a path "C:\Users\ankopr01\Documents\My Received Files" in which 300...
August 6th 16 05:31 PM
by banhtrungthu58 Go to last post
4 327
a twist on counting unique values in a range which contains blankcells, using a formula. the formula can't use SUMPRODUCT or FREQUENCY by pete
I need a formula, not VB code, to count the number of unique values in a column of up to 10,000 rows, some of which will be blank. The values may be numeric,...
August 4th 16 09:17 PM
by pete Go to last post
5 275
Capture # of Button pressed to pass to another form by jlclyde[_2_]
Hello, I have a form that has six buttons on it. I have another form that I would like to capture the button that was pressed. For instance if Bt1 is pressed...
August 4th 16 12:36 AM
by banhtrungthu68 Go to last post
4 287
Email on save by Paul Doucette
Is there a way I can set up my spreadsheet to send an email to alert others in my company that it has been updated, every time I save it? Thanks! Paul
(Multi-page thread 1 2 3)
August 4th 16 12:33 AM
by banhtrungthu68 Go to last post
24 834
Index and Match Help by Munster
A B C D E F G 1 PRODUCT PRODUCT DATE CODE LOCATION RESULT 2 APPLES AP16063 3 4 5 6 PRODUCT MFG Product...
August 3rd 16 12:27 PM
by banhtrungthu247 Go to last post
6 300
Error on paste by Paul Doucette
This code has worked in the past for copying an oval shape with a clear background from one sheet to another. (we use it to circle info we wish to draw...
July 27th 16 10:31 PM
by GS[_6_] Go to last post
5 286
ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly by David Godinger[_2_]
I’m using UserInterfaceOnly, so that I can run macros and still keep my sheet protected. I tried to use ActiveCell to calculate only certain ranges, without...
July 27th 16 04:07 AM
by edelkochen Go to last post
5 375
VBA - How to "execute" a dynamic variable assignment by [email protected]
Cell A1: "MyVar" Cell A2: "Purple" Cell A3: "String" I want to run code that does the following Public MyVar as String MyVar = "Purple"
July 20th 16 05:29 PM
by GS[_6_] Go to last post
7 439
"Continue?" Message Box by Paul Doucette
I have code that runs when a command button is triggered, that does several things, including saving the file. After that command button is triggered, and...
July 18th 16 12:05 AM
by Paul Doucette Go to last post
4 287
Number of records for last 7 days by R D S
Hello, You guys have been very helpful to me in the past. I have a spreadsheet with a column of dates, I would like a textbox on a form display the number...
July 17th 16 09:04 PM
by R D S Go to last post
3 286
Need Macro help to stop repeating some info by ksquirt
I am trying to tweak a macro by adding new rows into the tabs and then add them to the macros for compilation in an email. The issue I have is that the...
July 14th 16 08:48 PM
by ksquirt Go to last post
2 409
Convert Numeric Values in Column to Text via VBA by [email protected]
Does anyone have some VBA code that will convert all numeric values to text value in a certain column, in a certain worksheet? Eg convert 630 to '630 The...
3 357
Password Cracker for Excel Worksheets/ Workbooks by [email protected]
This has been floating around for a while now, but I gave it a serious reworking. Option Explicit Public Sub AllInternalPasswords() On Error Resume Next ' '...
(Multi-page thread 1 2)
July 13th 16 11:32 AM
by Raj[_12_] Go to last post
15 2,585
Click on Webpage Box by [email protected][_2_]
I have been trying to click on the box labeled "Select Weight & Count" on the following web...
0 308
data filter via VBA by Paul Doucette
I have a command button that runs code in order to assign a random number and save a workbook. I would like to add a step to this code so that it takes the...
July 11th 16 01:34 AM
by Paul Doucette Go to last post
2 279
Print, Save as PDF, Email PDF code by Paul Doucette
I am looking to assign vba code to a command button which will do the following: 1) Print worksheet “Quote” and worksheet “Sheet1” to my default...
July 10th 16 03:15 PM
by Paul Doucette Go to last post
7 343
Find and Replace Q by [email protected]
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...
2 296
Angry
Programing to save who and when someone update the file by [email protected]
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 275
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 327
Post New Thread


Display Options
Showing threads 121 to 140 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 07:16 AM.


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