Msgbox And Input Box To Hide Columns

May 29, 2012

I have sheet with Oval button and when I pressed the Oval button input box appears and ask for password and I made msgbox if the password is wrong and I made loop 4 times to enter the password then after for trials will exit the inputbox ,But I have 2 problem with my code below

1st problem : when i press the cancel button before I insert any character in Inputbox the msgbox appears which its say the password is wrong

2nd problem : when i press the cancel button before I insert any character in Inputbox the column which the Oval Button exist on it disappear.

Code:

Sub Hide_Sal_Table()
Const pass As String = "123"
Dim Inp
Dim Retry
Dim lTries As Long
Inp = InputBox("please enter the password", "Zmhnk", vbOKCancel + vbQuestion)
Application.ScreenUpdating = False

[Code] ........

View 1 Replies


ADVERTISEMENT

VBA To Hide Columns Based On Input Date Range?

Mar 26, 2014

I need some VBA code to hide columns if they are outside of a specified date range.

- the worksheet i need to run this VBA on is named 'Summary'
- Columns A to G need to remain un-hidden at all times
- from H17 to ZZ17 i have every month of the relevant years listed (all there chronologically)
- D3 holds the 'Date From' variable
- D4 holds the 'Date To' variable

View 11 Replies View Related

Msgbox :: Will Change Upon The Input?

Feb 12, 2010

I have managed to get a inpubox into a sheet which takes in data and returns a particular value. Is it possible to get a msgbox to be returned displaying the particular value which will change upon the input?

View 9 Replies View Related

Date Code For Input Into MsgBox

Feb 1, 2009

I have made a MsgBox which opens on Workbook opening with a message as follows:

View 4 Replies View Related

Hide Password Input

Jul 12, 2007

like PHP, you can enter a box and have it so what is entered is meant to be a password, so puts stars where the text is. I would like to do something like that with VB INPUT tag:


pw = Input ("Please enter Password:")

Is there a method I can add to this to make it cover the text being typed?

View 9 Replies View Related

Hide Columns & Hide X-axis Labels

Nov 22, 2006

I am filtering the data displayed in a chart by hiding columns. I would also like to filter the X-Axis labels by hiding columns. If I do this manually I have no problems but when I run the following macro the chart gives a reference error for the X-axis labels.

Sub ShowA2()
Application. ScreenUpdating = False
num = Sheets.Count
Sheets("X-Axis").Activate
Range(Columns(1), Columns(256)).Select
Selection.EntireColumn.Hidden = False
For a = 1 To 5
Sheets(num - a).Activate
If ActiveSheet.Name = "A2 Data" Then
Columns("A:Q").Select
Range("A10").Activate
Selection.EntireColumn.Hidden = False
Sheets("X-Axis").Activate
Columns("A:E").Select......................

View 3 Replies View Related

Hide Rows Beneath Except One For Input

Dec 30, 2006

I have two columns and each record in the spreadsheet fills both cells. I want all rows beneath the data to be hidden except for one, which is for the user to input a new record. When they are done completing the record, 1 row becomes unhidden (which will be for another inputted record). I also need it so that the new row becomes unhidden ONLY when the user inputs values in BOTH columns of the new record. I have already used Data Validation on each individual cell (column a is validated only for numeric entries and column b can only be picked from a drop-down list)

View 9 Replies View Related

Dropdown List With Prompt Box To Enter Value And Hide Input

Feb 5, 2013

I am looking to allow a user to enter a unique value when a drop down value is captured from a list i.e 'Other' (Possibly a pop up box), then I require this value to be hidden and calculated along with others to show the average (The average calculation obviously wouldn't be in the same cell).

View 8 Replies View Related

How To Hide Tabs And Make Them Appear After Specific User Input

Jul 10, 2014

I have nearly finished my project, but need to make the last real bit of code, then just some general tidying up.

What I want to do
- I currently have two tabs in a userform - one called 'main' and one called 'extra'.
- I want Main to always be shown to the user.
- I want Extra to be hidden (is it possible to make the tabs invisible?) and for this form to be shown only under a specific condition

I have a question on my userform (using Option Buttons):
"Did the customer ask about an extra product today?"

If the answer to this question is no - When the user hits the command button (after filling out the rest of the form), do nothing special - just return all the values to the worksheet

If the answer is yes - When the user hits the command button, I want them to be taken to the 'extra' tab. They will fill out some additional check-boxes, then hit another command box, which will return the info from both the 'main' and 'extra' sheets into the same row of the worksheet.

In brief: I want my 'extra' tab to be hidden, only to appear when 'yes' is selected, and for the results all to go back to the worksheet.

View 6 Replies View Related

Hide And Delete Sheets Based On Cell Input?

Aug 11, 2014

I have a situation where i would like to hide and delete a few sheets in my worksheet.

there is a few sheets where i want it to be constantly visible and one sheet is based on a cell reference.

the remaining irrelevant sheets i would like it to be hidden and deleted.

'always visible are sheets that are constantly visible in all files' 'visible msds is the sheet where my product data is being pulled out based on a input i enter on my first sheet' the sheets i want to hide and delete will be the remaining irrelevant "MSDS" that i would like to remove through macro.

View 3 Replies View Related

Locate CSV File With Open File Msgbox And Import Columns From CSV To Worksheet

Oct 28, 2011

Actually i've downloaded Tracking report of my SPO and this report is on 4-5 csv files (1 file per week). I have to gather data from these 4 files into one Worksheet. I have to do this with command button on my worksheet; with Open file dialogue box (i want to locate the csv files).

CSV files are something like that (I need only first 4 columns):

ABCDE1Name MSISDN Date Location MapLink 2M. Younus Safi "923***550577" "2011-10-07 20:36:18" "ACB Tower Badragah Chakwal. Badraga" "http://asdf.com" 3M. Younus Safi "923***550577" "2011-10-07 19:36:26" "ACB Tower Badragah Chakwal. Badraga" "http://asdf.com" 4M. Younus Safi "923***550577" "2011-10-07 16:39:58" "ACB Tower Badragah Chakwal. Badraga" "http://asdf.com" 5M. Younus Safi "923***550577" "2011-10-07 15:37:23" "ACB Tower Badragah Chakwal. Badraga" "http://asdf.com" 6M. Younus Safi "923***550577" "2011-10-07 14:37:05" "ACB Tower Badragah Chakwal. Badraga" "http://asdf.com"

and my Worksheet is like that (With a command Button):

I want to import first 3 columns of csv file on first 3 columns on my worksheet; leave 2 columns blank and then import the 4th column... now for example i have done importing data from 1st csv file and the data is on 50 rows.. i click the command button again, locate the 2nd csv file.. do the same thing (import 1st 3 columns, 2 blank, then 4th) --from 51st Row-- and so on...

ABCDEF1NameMSISDN DatedBlankBlank Location2

3

4

5

6

7

View 4 Replies View Related

VBA - Select Row Number From Input Box And Delete Specified Columns From That Row

Jun 11, 2013

I have an input box which asks the user to select a row that they wish to delete.

What I need to do is take the row number that has been selected and delete cells B:K and move the below cells up.

View 1 Replies View Related

Hide Various Columns

Jan 11, 2010

I have a very large spreadsheet that I work in and then print from. When I print, I need to hide about 20 columns which I do manually. I am curious if there is a way I can do this easier. If I could somehow filter columns, or set mutliple columns to a name for a dopr dowm box, or possibly a macro.

View 9 Replies View Related

Hide Columns

Feb 1, 2007

I am trying to use an IF formula to do the following for each row in a large spreadsheet: If the value in column W = 0, show columns A,B,C and E. I have one formula I've used that doesn't work, but as posting what I think is the correct answer could get my post deleted, I won't put it here.

View 3 Replies View Related

Hide Columns Where Row X Has Zero

Sep 12, 2007

I have found vba to hide rows that contain zero values, but not columns.

View 6 Replies View Related

Conditional Formatting Columns Based Off Cell Input

Jun 24, 2014

Instructions are in the attached excel as well. Please see attached

If a person puts in a price in column A, that results in column B "Everyday Price Per Unit" being greater than column C "NDP", then highlight column A cell input red.

=Column B>Column C, then turn input cells in Column A Red.

First four highlighted are examples of thise formula scenario

** All based off an input into column

How to use conditional formatting to do so???

Excel Conditional Formatting 06.24.14.xlsx‎

View 5 Replies View Related

Multiply By Info In Different Columns - Selected By Input In Cell

Mar 19, 2014

I'm trying to make a sheet to calculate my taxes. I would like to keep tax rates from previous year(s), and have them applied based on which year I input in a cell..

Let say that in cell B1 I write year 2013

In cell G1 I have year 2013 and in cells G2:G7 I have tax rates from year 2013.
In cell H1 I have year 2014 and in cells H2:H7 tax rates from year 2014

In cell B17 to B20 I would like to make a formula that multiplies cell B11 or B12 with information found in either column G or H based on input in B1.

I have attached a spread sheet as example.

I know I can make a formula based on IF(B1=2013;G*;IF(B2=2014;H*;etc..

View 3 Replies View Related

Macro To Unhide Columns Based On A Users Input

Apr 2, 2014

I'd like for my spreadsheet to open with only Column A visible; I'd like all other collumns to stay hidden.

I want to create a marco to unhide column(s) based on the value of an individual cell.

For example:

if I enter the number 5 into cell A1, I would like Columns B:F to unhide.
if I enter the number 2 into cell A1, I would like Columns B:C to unhide. Is this possible?

View 10 Replies View Related

Command Button Prompt To Input 2 Columns Of Data

Jul 19, 2014

My new Time in Motion sheet is coming along nicely with some snazzy programmed Command Buttons to fill data into another sheet.

One of my buttons is for 'other' tasks, so I'd like to programme a button to prompt first for a number of minutes (e.g. 30), and then a brief description (e.g. Meeting) and input the data side-by-side in 2 columns on sheet 2.

This is what I have for my other single-entry buttons, so what would I need to add?

Dim ans As String
ans = InputBox("Case reference:", "Data Entry")
Sheets("Sheet2").Range("F" & Sheets("Sheet2").Range("F" & Rows.Count).End(xlUp).Row + 1).Value = ans

View 1 Replies View Related

Order Columns & Tabs Based On User Input

Jan 9, 2009

How would I reorder columns & tabs based on a form where the user can put them into order that they would like the columns? I forsee some type of form where the user can dsignate the order and then start a macro that will sort both the columns and tabs.

View 5 Replies View Related

Hide/Unhide The Columns

Jun 16, 2009

I've come across a spreadsheet where certain rows and columns (typically top rows or left columns) are hidden; however, there's no way to unhide them (the unhide function is grayed out) and it doesn't seem to be protected or no visible macros/vba on the file.

View 3 Replies View Related

Hide/Unhide Columns

Dec 19, 2008

I have a spreadsheet that has 28 columns for time entries. Typically only the first 12 columns are used, so I would like to hide the remaining 16 columns (which makes the spreadsheet much more user-friendly). It would probably be nearly impossible to teach all of them how to Unhide the remaining columns (and re-Hide), plus I would like to use the full-screen function when employees enter thier times. I would like to use a form control in the column heading so that when the employees 'check' it, it will Unhide and then re-Hide the columns. Any way to do this? Seems like a VB thing to me (out of my league, but would be happy to add one in!).

View 2 Replies View Related

Hide Columns Via A Macro ...

Jun 11, 2009

I have created this macro (below) in a standalone spreadsheet and the expected results are that Columns A,B,C,D,G,H will be displayed after I run the macro.

But when I use the same macro in my production worksheet (columns and ranges adjusted accordingly) this macro creates the following results: Column A is displayed and all the rest are hidden (B,C,D,E,F,G,H). I am stumped as to why this occurs. Can you advice me as to how to get this macro to work and display A,B,C,D,G,H ?

View 7 Replies View Related

Hide Unsequential Columns In Vba

Nov 13, 2009

I'm using Excel 2003 and want to hide columns D:E & I:J. I have script as follows which hides I:J but I am unsure how to get it to include the other 2 columns.

View 4 Replies View Related

VBA To Unhide And Hide Columns?

Oct 23, 2002

I want to create two buttons.. one name HIDE and the other UNHIDE.

What I need hide button to do when i click it is hide the 4 columns to the right (not always going to be columns b:e)

For the unhide button unhide the 4 columns to the right (not always going to be columns b:e)

View 9 Replies View Related

Hide / Unhide Columns By The Use Of + And -

Mar 5, 2013

I once saw an excel sheet where I could hide or unhide a section by some + and - signes above the column-letters.... I have searched for this but I only get the ordinary hide/unhide solutions.

View 4 Replies View Related

Hide Columns With If / Then Statement

Jun 23, 2013

I'm attempting to put code in that will hide 2 individual columns when a particular cell in another column has no value in it. The cell, however, has a formula in it, and I'm not sure if that is my issue.

Essentially, if the formula in A32 returns a value, I need columns M and P to Hide. If it doesn't return a value, I need them to stay put. The value returning in A32 is a number, but it can be treated as text as it is an ID number and is not needed for any calculation.

Here's how I have it set up now:

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A32") "" Then
Columns("M","P").EntireColumn.Hidden = True
Else
Columns("M","P").EntireColumn.Hidden = False
End If
End Sub

It's not working - nothing is happening.

View 5 Replies View Related

Hide Columns On Condition

Jun 12, 2014

Using VBA or by other means, I want to disable user entry in cells G1 to X1 if the user places a value in A1, similarly if the user places a value in A2 then disable user entry in cells G2 to X2, and so on.

View 7 Replies View Related

Dynamically Hide Columns

May 15, 2007

I am using drop-down lists in a cell to filter out some data in a spreadsheet. Works great, but I would like to hide certain columns depending on which item is selected in the drop-down list. I have written a macro to do this, but I cannot get the macro to run automatically every time there is a change in the drop-down list.

View 9 Replies View Related

Hide Columns On Opening - IF

Apr 9, 2008

The other day I had posted a thread asking if anyone could help me ensure certain columns were hidden when a .xls was opened.
Here-> http://www.mrexcel.com/forum/showthread.php?t=312938

Now Id like to be able to hide the columns only if row B of the colum contains the text "hide me". Please not the cell may contain other text, such as "Q1, hide me"

Anyone know if its possible?

eg I want to hide Cols B and D

1ABCD2Shop items3dateQ1, hide meItemSupplier, hide me401/01/2006q1 2006JuicePepsi505/01/2008q1 2008crispswalkers

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved