Excel VBA form - Visual Basic 4 / 5 / 6

squidge1990

Im trying to get a form to display a certain sheet when a button is clicked on a form. but i have found a problem when the button is clicked it will go to the correct sheet but it will not hide the form that the button is on. here is the code that i have produced for this. if any could help i would be very thankful.

Expand|Select|Wrap|Line Numbers

 Private Sub CommandButton19_Click()

Worksheets("Accounts").Visible = True

HighLevel.Hide

'BackForm.Show

Worksheets("Accounts").Select

End Sub

thanks

Dec 11 '06 #1

Subscribe Post Reply

2026

Killer42

8,435

Expert 8TB

Im trying to get a form to display a certain sheet when a button is clicked on a form. but i have found a problem when the button is clicked it will go to the correct sheet but it will not hide the form that the button is on. here is the code that i have produced for this. if any could help i would be very thankful.

Expand|Select|Wrap|Line Numbers

Private Sub CommandButton19_Click()

Worksheets("Accounts").Visible = True

HighLevel.Hide

'BackForm.Show

Worksheets("Accounts").Select

End Sub

thanks

Perhaps you need to do the hide after the select?

Dec 11 '06 #2

squidge1990

Perhaps you need to do the hide after the select?

that doesn't work it still seems to do the same as it did before thank anyways

Dec 12 '06 #3

Similar topics

how to secure Excel file on webserver?

by: Rich | last post by:

Hi, I have a bunch of Excel reports that I would like to display on my company's intranet. The reports contain priviledged information, however. My plan was to have a page with a dropdown box...

ASP / Active Server Pages

ASP to Excel

by: Konstantin Loguinov | last post by:

Guys, I have been killing myself over this one for a while and can't find what is wrong. Here is the problem... I have an ASP application that claculates certain values. It used to be in...

ASP / Active Server Pages

Excel automation from .net

by: Erling | last post by:

I am automating an Excel Spreadsheet from a .net windows app. I have no problem automating various Excel cells based upon the following declarations. My question is how do I open an Excel Form...

.NET Framework

open excel and run macro on button click

by: VbUser25 | last post by:

hi.. i have a form i accept some user inputs in the form. there is a link on the form from where i open the excel file in the same browser (not in a new page...simply using a href. i am also...

ASP / Active Server Pages

C# Aplpication talking to Excel Add-In

by: Matthew Wieder | last post by:

I have the following requirements: Build a stand-alone C# application that asks the user to click in a cell in an Excel spreadsheet, and then displays the address of that cell in the C#...

C# / C Sharp

Automating Excel from VB .NET

by: Howard Kaikow | last post by:

There's a significant problem in automating Excel from VB .NET. Reminds me of a problem I encountered almost 3 years ago that was caused by the Norton Auntie Virus Office plug-in. Can anybody...

Visual Basic .NET

export datagrid to Excel

by: Frank | last post by:

Hello All, I ham using VS.NET 2003. Have followed instructions from http://gridviewguy.com/ArticleDetails.aspx?articleID=26 along with several other articles to no avail. I am pulling my hair...

C# / C Sharp

Excel Instance won;t die if coping cell content to struct

by: alexia.bee | last post by:

Hi all, In some weird reason, excel instance won;t die if i remove the comment from 4 lines of setting values into struct. here is a snipcode public...

C# / C Sharp

Transfer data from a sub form and main form to excel spreadsheets

by: chuch0117291 | last post by:

Hi, i have a form with the main details of a vendor and and contract description and a budget reference(PK). Within this form, i have a sub form which includes cost details for that specific vendor...

Microsoft Access / VBA

Opening Excel from Access

by: Phil Stanton | last post by:

I have a form with a button which is supposed to open an Excel file (With lots of Macros /VBA) in it. The Excel file gets it's data from the Access program Here is the code Private Sub...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA