We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Programmatically changing the Worksheet that is currently visible

Thread ID:

Created:

Updated:

Platform:

Replies:

141630 Dec 21,2018 04:24 PM UTC Dec 24,2018 01:42 AM UTC WinForms 2
loading
Tags: Spreadsheet
Spotty
Asked On December 21, 2018 04:24 PM UTC

Trying to change the currently activateworksheet within a workbook. I have modified code on the appropriate worksheet and can see this but cannot change the currently activateworksheet to ensure that this tab is the displayed one.
Am I missing something ?

Dim SourceTab = ComboBox3.Text
If String.IsNullOrWhiteSpace(SourceTab) Then
Exit Sub
End If
'Some code to change the content on the Spreadsheet2.Workbook.Worksheets(SourceTab)
Spreadsheet2.ActiveSheet = Spreadsheet2.Workbook.Worksheets(SourceTab)
Spreadsheet2.Workbook.Worksheets(SourceTab).Activate()

Spotty
Replied On December 23, 2018 01:25 AM UTC

figured it out and used 

Spreadsheet.SetActiveSheet("Name")



Arulraj A [Syncfusion]
Replied On December 24, 2018 01:42 AM UTC

Hi Spotty, 

Thanks for the update. 

We are glad to know that the reported problem has been resolved at your end. Please let us know if you have any further queries on this. We are happy to help you. 

Regards, 
Arulraj A 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;